RE: [flexcoders] Is it possible to return multiple recordsets to Flex from one Remote Object call

dfatta Fri, 19 Aug 2005 12:21:45 -0700

Allen & Stephen,

Thank you both for you advice. I like your ideas of passing back an Array of Value Objects. I've read only generalities on how to actually code this. Currently, my Flex app calls a cfc that includes a query and populates an Array of Structures. I took a stab at trying to re-code this but have gotten stuck (code below). I think I'm still unclear as to how to build an array of VOs (let alone returning multiple one's). Can you take a look?

BTW, I just finished Chapter 8 of your great book, Stephen! I know all us Flex newbies are indebted to you for this invaluable resource.

Best regards,

Darius

Flex:

------------------------

private function getObject():Void{
   var aperson :Object = new Object();
   aperson.username="dfatta";
   aperson.CCode= "37";
   aperson.CFlag="No";
   aperson.COAFlag = "No";
   ro.getObject({p:aperson});
  }

CFC:

------------------------------------

-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED]On Behalf Of Allen Manning
Sent: Friday, August 19, 2005 5:19 AM
To: [email protected]
Subject: RE: [flexcoders] Is it possible to return multiple recordsets to Flex from one Remote Object call

Darius,

I don’t know, passing back an uber array feels a bit monolithic (but maybe good for performance?). Why not break them down into different Array’s of Value Objects.

For example:

EmployeeListVO – array of Employee VOs

InvoiceListVO – array of Invoice VOs

FooListVO – array of Foo VOs

Now you have the fine grained control of just asking for one or all of them. And you can do what you want with each. We represent our VOs as CFCs. This allows you to type the package path in the returnType attribute of your CFCs. Queries and Structures are not typed, you could get anything back and ColdFusion won’t report any problems. How do you check for a well formed Struct or a well formed Query? You might also want to look at the advantages of automatic object conversion into ActionScript. You could have a 1:1 mapping between FooVO.cfc and FooVO.as.

Hope that helps,

Allen

www.prismix.com/

From: [email protected] [mailto:[email protected]] On Behalf Of Mika Kiljunen
Sent: 19 August 2005 06:42
To: [email protected]
Subject: RE: [flexcoders] Is it possible to return multiple recordsets to Flex from one Remote Object call

Why not return an arrray containing recordsets and then setting the recordsets from the array as dataproviders to your controls by actionscript as follows:

resultArray looks like:

            [0] Recordset1 (an array of resultobjects from query 1)

            [1] Recordset2 (an array of resultobjects from query 2)

            [2] Recordset3 (an array of resultobjects from query 3)

            ….

And:

myGrid.dataProvider = resultArray[0];

            myOtherGrid.dataProvider = resultArray[1];

            …

-Mika

From: [email protected] [mailto:[email protected]] On Behalf Of coldfs
Sent: 19. elokuuta 2005 3:40
To: [email protected]
Subject: [flexcoders] Is it possible to return multiple recordsets to Flex from one Remote Object call

Hi,

My Flex app connects to a large ColdFusion application. When I make
calls from Flex via RO to CF, I need to return more than one
recordset in order to populate my various datagrids. I know how to
return one recordset as an Array of Structures, but what if I have 5
different querries that have 5 different recordsets. How does one
deal with this?

Many thanks for any clarification one can give.

Darius

--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.10.12/77 - Release Date: 18/08/2005

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.10.12/77 - Release Date: 18/08/2005

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

YAHOO! GROUPS LINKS

Visit your group "flexcoders" on the web.
To unsubscribe from this group, send an email to: [EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

RE: [flexcoders] Is it possible to return multiple recordsets to Flex from one Remote Object call

Reply via email to