This is an interesting take. I wouldn't jump at seeing a Query of Queries as being the solution (again, I like Allen's), but let me comment that you are on a good track in recognizing that there's an aspect of query result reuse that would be useful. I'd propose query caching instead, but that's a whole separate subject that I'll address in a later note.
/Charlie http://www.carehart.org/blog/ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Ross Sent: Friday, February 02, 2007 1:33 PM To: [email protected] Subject: Re: [ACFUG Discuss] CFC and reuse query Seems like you would just select them all and do a QoQ... probably the fastest way to do it but, that may not be true depending on the number of records you are returning. So query for all and then go check out QoQ http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/h tml/wwhelp.htm?context=ColdFusion_Documentation&file=00001265.htm snippet from livedocs referenced above: To use the results of a query in a query: <snip> ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
