Hi all, The destination is Flex and although my question is a little Backend oriented, I assume that many developers have faced this.
I have a VO in my application called Lenders. Each Lender has x number of Locations (a collection of VOs represented by an ArrayCollection called lender.locations) Each Location has x number of Contacts (another collection of VOs represented by an ArrayCollection called lender.selectedLocation.contacts) Anyway, the question is simple. I have 3 tables in a SQL Server 2005 DB which I use Coldfusion to query. The database tables (which are related by FK ids) will populate the object. is there anyway for the SQL Query to do that work? Meaning a hierarchy? I would want it to return like this. Lender Location Contact Contact Location Contact Location You get the idea. is that possible or do I have to loop over the Queries in Coldfusion and build them into structs? Thanks. -- 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 <*> To visit your group on the web, go to: http://groups.yahoo.com/group/flexcoders/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/flexcoders/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
