Ok... I did more research, and have found that in Flex 2, you DO NOT have to do any special conversions on the ColdFusion side. The Flex 2 Gateway automatically changes the query object to an ArrayCollection.
 
I fixed up my application, and the app & source code is below. My CFC just returns query objects.
 
 
Shan


From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Shannon Hicks
Sent: Thursday, June 22, 2006 4:20 PM
To: flexcoders@yahoogroups.com
Subject: RE: [Junk E-Mail - LOW] [Junk E-Mail - LOW] [Junk E-Mail - LOW] [flexcoders] Re: Noob binding question

Ah-hah! I was trying to return a query.
 
> > The problem is I'm trying to get data from a query returned by a
> CFC into a
> > datagrid. Before, I was having problems getting data back.
 
I never suspected that Adobe would take away behaviors from flash remoting & flash CFFORM's... I didn't notice that I had to transform a query into an array of structures before sending it back to flex. Seems like a huge oversight to me, Adobe.... now I can't re-use my already built CFC's from existing applications... I have to tweak them all.
 
Am I missing something, or is that the only way to return a query?
 
Shan


From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Tim Hoff
Sent: Thursday, June 22, 2006 2:44 PM
To: flexcoders@yahoogroups.com
Subject: [Junk E-Mail - LOW] [Junk E-Mail - LOW] [Junk E-Mail - LOW] [flexcoders] Re: Noob binding question

Let's back-out a little. What does your cfc look like? What are
you trying to return?

-TH

--- In [EMAIL PROTECTED]ups.com, "Shannon Hicks" <[EMAIL PROTECTED]> wrote:
>
> Did that, and when I view the debugger, I find the
arraycollection, and it
> contains what the datagrid is *literally* showing...
>
>
> *
>
> serverLoadDataArray = Array
>
> *
>
> [0] = mx.collections.ArrayCollection
>
> *
>
> filterFunction = null
> *
>
> length = 100
> *
>
> list = mx.collections.ArrayList
>
> *
>
> length = 100
> *
>
> source = Array
> *
>
> uid = D414D735-DA38-AC66-6D7A-FD208817F35E
>
> *
>
> sort = null
> *
>
> source = Array
>
> *
>
> length = 1
>
> On the flip side... that is also exactly what I see under
event.result in
> the debugger.
>
> Shan
>
>
> _____
>
> From: [EMAIL PROTECTED]ups.com
[mailto:[EMAIL PROTECTED]ups.com] On
> Behalf Of Tim Hoff
> Sent: Thursday, June 22, 2006 12:11 PM
> To: [EMAIL PROTECTED]ups.com
> Subject: [Junk E-Mail - LOW] [Junk E-Mail - LOW] [flexcoders] Re:
Noob
> binding question
>
>
>
> Hi Shannon,
>
> Set a breakpoint right after you cast the result to the array
> collection and inspect the array contents in debug mode. Check to
> see if the array looks correct and what the dataField names are
> exactly. If everything looks good, use the same dataField names
for
> the coulmns. It does look like you have data.
>
> -TH
>
> --- In HYPERLINK
> "mailto:flexcoders%40yahoogroups.com"flexcoders@..., "Shannon
> Hicks" <shan@> wrote:
> >
> > The problem is I'm trying to get data from a query returned by a
> CFC into a
> > datagrid. Before, I was having problems getting data back.
> >
> > Now I've got the data back, and it won't display (I was getting
an
> empty
> > datagrid). So, I removed my user-defined columns, to see what
was
> coming
> > back, and the result is:
> >
> > FilterFunction, length, list, sort, source
> > HYPERLINK
> > "HYPERLINK
> "http://work.iotashan.com/hlstatsx/hlstatsx.html"http://work.-
iotashan.-com/
> hlstatsx/-hlstatsx.-
html"HYPERLINK "http://work.iotash"http://work.-iotash
> an.com/hl
> > statsx/hlstatsx.-html
> >
> > Those are not the columns of the query... I'm guessing they're
> properties of
> > the ArrayCollection, or maybe even the datagrid itself.
> >
> > Shan
> >
> >
> > _____
> >
> > From: HYPERLINK
> "mailto:flexcoders%40yahoogroups.com"flexcoders@...
> [mailto:HYPERLINK
> "mailto:flexcoders%40yahoogroups.com"flexcoders@...] On
> > Behalf Of Tracy Spratt
> > Sent: Thursday, June 22, 2006 11:39 AM
> > To: HYPERLINK
> "mailto:flexcoders%40yahoogroups.com"flexcoders@...
> > Subject: RE: [Junk E-Mail - LOW] [flexcoders] Re: Noob binding
> question
> >
> >
> >
> >
> > "When I remove my columns from the datagrid, the datagrid shows
> these
> > columns from the dataprovider:-" I do not understand this. Did I
> miss
> > something in a previous post? Can you re-phrase the problem?
> >
> > Tracy
> >
> > _____
> >
> > From: HYPERLINK
> "mailto:flexcoders%40yahoogroups.com"flexcoders@...
> [mailto:HYPERLINK
> "mailto:flexcoders%40yahoogroups.com"flexcoders@...] On
> > Behalf Of Shannon Hicks
> > Sent: Thursday, June 22, 2006 12:15 PM
> > To: HYPERLINK
> "mailto:flexcoders%40yahoogroups.com"flexcoders@...
> > Subject: RE: [Junk E-Mail - LOW] [flexcoders] Re: Noob binding
> question
> >
> > Oh... URL to the problem:
> >
> > HYPERLINK
> > "HYPERLINK
> "http://work.iotashan.com/hlstatsx/hlstatsx.html"http://work.-
iotashan.-com/
> hlstatsx/-hlstatsx.-
html"HYPERLINK "http://work.iotash"http://work.-iotash
> an.com/hl
> > statsx/hlstatsx.-html
> >
> > ShanHYPERLINK "HYPERLINK
> "http://work.iotashan.com/"http://work.-iotashan.-com/"
> >
> > _____
> >
> > From: HYPERLINK
> "mailto:flexcoders%40yahoogroups.com"flexcoders@...
> [mailto:HYPERLINK
> "mailto:flexcoders%40yahoogroups.com"flexcoders@...] On
> > Behalf Of Shannon Hicks
> > Sent: Thursday, June 22, 2006 10:23 AM
> > To: HYPERLINK
> "mailto:flexcoders%40yahoogroups.com"flexcoders@...
> > Subject: RE: [Junk E-Mail - LOW] [flexcoders] Re: Noob binding
> question
> >
> > I did the changes you suggested, and I can successfully make the
> request and
> > get the response back.
> >
> > Unfortunately, it looks like there's something wrong with my
> > ArrayCollection.-... When I remove my columns from the datagrid,
> the datagrid
> > shows these columns from the dataprovider:
> >
> > FilterFunction, length, list, sort, source
> >
> > *now* what'd I do wrong? :)
> >
> > Shan
> >
> > _____
> >
> > From: HYPERLINK
> "mailto:flexcoders%40yahoogroups.com"flexcoders@...
> [mailto:HYPERLINK
> "mailto:flexcoders%40yahoogroups.com"flexcoders@...] On
> > Behalf Of Tim Hoff
> > Sent: Wednesday, June 21, 2006 10:03 AM
> > To: HYPERLINK
> "mailto:flexcoders%40yahoogroups.com"flexcoders@...
> > Subject: [Junk E-Mail - LOW] [flexcoders] Re: Noob binding
question
> >
> > Hi Shannon,
> >
> > Here's a couple things that might get you moving forward.
> >
> > First, add a fault handler to your RPC, to see if the CFC result
> is getting
> > through:
> >
> > fault="Alert.-show(event.-fault.faultstrin-g, 'Error');"
> >
> > And, some subtle changes to your functions:
> >
> > private function appInit():void
> > {
> > cfcServer.getServer-Info.send(-);
> > cfcServer.getServer-Load.send(-);
> > }
> >
> > function serverInfoResult(-event:ResultEven-t):void
> > {
> > var serverInfoDataArray : Array =
> > mx.utils.ArrayUtil.-toArray(event.-result);
> > serverInfoData = new ArrayCollection
> (serverInfoDataArra-y);
> > }
> >
> > Finally, check to see if the fields that you are binding to the
> DataGrid
> > columns are syntactically the same as the CFC query. Someone
> earlier
> > suggested using all CAPS for the field names. But, I was under
the
> > impression that they were case-sensitive.
> >
> > Besides that, It looks like it should work. Good luck.
> > -TH
> >
> >
> > --- In HYPERLINK
> "mailto:flexcoders%40yahoogroups.com"flexcoders@..., "Shannon
> Hicks" <shan@> wrote:
> > >
> > > I've racked my brain, and searched all the documentation I
could
> find, but
> > > seem to be having a problem binding results from a CFC query
to
> flex
> > > objects...
> > >
> > > I know I'm doing the chart all wrong, but I tried binding to a
> datagrid,
> > and
> > > I don't see what's wrong there. I can confirm that the CF
server
> is
> > getting
> > > the request, and is sending back the proper number of rows.
> > >
> > > Here's the app I've been toying with:
> > >
> > > HYPERLINK
> > >
> > "HYPERLINK
> "http://flex.work.iotashan.com/hlstatsx/hlstatsx.html"http://flex.-
work.iota
> shan.-com/hlstatsx/-hlstatsx.-
html"HYPERLINK "http://flex.w"http://flex.-w
> ork.iotas
> > > han.com/hlstatsx/-hlstatsx.-html
> > >
> > > You can view the source on it.
> > >
> > > Thanks for the help,
> > > Shan
> > >
> > >
> > >
> > > --
> > > No virus found in this outgoing message.
> > > Checked by AVG Free Edition.
> > > Version: 7.1.394 / Virus Database: 268.9.2/370 - Release Date:
> 6/20/2006
> > >
> >
> > --
> > No virus found in this incoming message.
> > Checked by AVG Free Edition.
> > Version: 7.1.394 / Virus Database: 268.9.2/370 - Release Date:
> 6/20/2006
> >
> > --
> > No virus found in this outgoing message.
> > Checked by AVG Free Edition.
> > Version: 7.1.394 / Virus Database: 268.9.2/372 - Release Date:
> 6/21/2006
> >
> > --
> > No virus found in this incoming message.
> > Checked by AVG Free Edition.
> > Version: 7.1.394 / Virus Database: 268.9.2/372 - Release Date:
> 6/21/2006
> >
> > --
> > No virus found in this outgoing message.
> > Checked by AVG Free Edition.
> > Version: 7.1.394 / Virus Database: 268.9.2/372 - Release Date:
> 6/21/2006
> >
> >
> >
> >
> > --
> > No virus found in this incoming message.
> > Checked by AVG Free Edition.
> > Version: 7.1.394 / Virus Database: 268.9.2/372 - Release Date:
> 6/21/2006
> >
> >
> >
> > --
> > No virus found in this outgoing message.
> > Checked by AVG Free Edition.
> > Version: 7.1.394 / Virus Database: 268.9.2/372 - Release Date:
> 6/21/2006
> >
>
>
>
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.394 / Virus Database: 268.9.2/372 - Release Date:
6/21/2006
>
>
>
> --
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.1.394 / Virus Database: 268.9.2/372 - Release Date:
6/21/2006
>


--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.9.2/372 - Release Date: 6/21/2006


--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.9.2/372 - Release Date: 6/21/2006


--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.9.2/372 - Release Date: 6/21/2006

__._,_.___

--
Flexcoders Mailing List
FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt
Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com





SPONSORED LINKS
Web site design development Computer software development Software design and development
Macromedia flex Software development best practice


YAHOO! GROUPS LINKS




__,_._,___

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.9.3/374 - Release Date: 6/23/2006

Reply via email to