That's cool - didn't know that. I'm using web services for now.
The
return result is an object. It can be accessed directly. But,
I've found
that by casting the result to an Array, which is used by
multiple
ArrayCollections, you can have multiple bound views, each
with different
filter functions, that don't affect the underlying
data. Just my personal
use.
-TH
--- In [EMAIL PROTECTED]ups.com,
"Shannon Hicks" <[EMAIL PROTECTED]> wrote:
>
> 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.
>
> HYPERLINK
> "http://flex.work.iotashan.com/hlstatsx/hlstatsx.html"http://flex.w
ork.iotas
>
han.com/hlstatsx/hlstatsx.html
>
> Shan
>
>
_____
>
> From: [EMAIL PROTECTED]ups.com
[mailto:[EMAIL PROTECTED]ups.com]
On
> Behalf Of Shannon Hicks
> Sent: Thursday, June 22, 2006 4:20
PM
> To: [EMAIL PROTECTED]ups.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: [EMAIL PROTECTED]ups.com
[mailto:[EMAIL PROTECTED]ups.com]
On
> Behalf Of Tim Hoff
> Sent: Thursday, June 22, 2006 2:44
PM
> To: [EMAIL PROTECTED]ups.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 HYPERLINK
>
"mailto:flexcoders%40yahoogroups.com"flexcoders@...,
"Shannon
> Hicks" <shan@> 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: HYPERLINK
>
"mailto:flexcoders%40yahoogroups.com"flexcoders@...
>
[mailto:HYPERLINK
>
"mailto:flexcoders%40yahoogroups.com"flexcoders@...] On
>
> Behalf Of Tim Hoff
> > Sent: Thursday, June 22, 2006 12:11
PM
> > To: HYPERLINK
>
"mailto:flexcoders%40yahoogroups.com"flexcoders@...
> >
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
> >
"HYPERLINK
> "http://work.iotashan.com/hlstatsx/hlstatsx.html"http://work.-
iotashan.-com/
>
hlstatsx/-hlstatsx.-html"HYPERLINK "http://work.-"http://work.--
> iotashan.-com/
>
> hlstatsx/-hlstatsx.--
> html"HYPERLINK "HYPERLINK "http://work.iotash"http://work.-
iotash"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
> >
"HYPERLINK
> "http://work.iotashan.com/hlstatsx/hlstatsx.html"http://work.-
iotashan.-com/
>
hlstatsx/-hlstatsx.-html"HYPERLINK "http://work.-"http://work.--
> iotashan.-com/
>
> hlstatsx/-hlstatsx.--
> html"HYPERLINK "HYPERLINK "http://work.iotash"http://work.-
iotash"HYPERLINK
> "http://work.-iotash"http://work.--iotash
> >
an.com/hl
> > > statsx/hlstatsx.--html
> > >
> > > ShanHYPERLINK "HYPERLINK
> > "HYPERLINK
> "http://work.iotashan.com/"http://work.-iotashan.-com/"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.faultstri-n-g,
'Error');"
> > >
> > > And, some subtle changes to your
functions:
> > >
> > > private function
appInit():void
> > > {
> > >
cfcServer.getServer--Info.send(--);
> > >
cfcServer.getServer--Load.send(--);
> > > }
> >
>
> > > function
serverInfoResult(--event:ResultEve-n-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
> >
"HYPERLINK
> "http://flex.work.iotashan.com/hlstatsx/hlstatsx.html"http://flex.-
work.iota
>
shan.-com/hlstatsx/-hlstatsx.-html"HYPERLINK "http://flex.-
"http://flex.--
> work.iota
> >
shan.-com/hlstatsx/--hlstatsx.--
> html"HYPERLINK "HYPERLINK "http://flex.w"http://flex.-w"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
>
>
>
> --
> 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
>