bingo +-----------------------------------------------+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis -----Original Message----- From: Joseph Thompson [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 8:12 AM To: CF-Talk Subject: Re: Which Is Faster, multiple CFQuery or Multiple Query of a Query? In many situations though simpy GROUP'ing the data with CFOUTPUT would eliminate the need for any other queries at all... (just a thought) > Agree Keen, the first query is local then the query of that query does not > need to exercise the database again. ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists