There are lots of ways to accomplish that. The simplest way seems to be with SQL JOINs and group the output.
-----Original Message----- From: Rick Faircloth [mailto:[email protected]] Sent: Wednesday, May 27, 2009 1:39 PM To: cf-talk Subject: What's the best way to handle returning two queries from a component for looping? Hi, all... After a *lot* of work in jQuery, specifically AJAX, I'm finally back some more *friendly* territory with CF again as a focus. Anyway, I'm expanding my ability to use cfc methods and have just run into a situation where I need to do a typical "loop one query to get a title" and "loop another query inside the first query to output details from another query", so I get: Title 1 - details 1 - details 2 - details 3 Title 2 - details 1 - details 2 - details 3 Instead of: Title 1 - details 1 Title 1 - details 2 etc... This is a no-brainer for standard "on-page" queries, but getting the info back from a method(s) is a little trickier. It's a little dark in the room and so far, no light bulbs have come on over my head... Do I have to return two queries in a struct? Can I loop the structs as I do queries? Is this where methods and extend other methods come into play? I read part of a chapter online from one of the CF8 books which seemed to use a getMetaData function or something like that to loop over parts of extended functions...I didn't quite understand that brief explanation. Hoping someone can point me in the right direction...approach to take? Tutorial for this? Thanks for any advice. Rick -- ------------------------------------------------------------------------ ------------------------------------------------------------------------ -- "Ninety percent of the politicians give the other ten percent a bad reputation." Henry Kissinger ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322844 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
