If you really need the 6 queries, you can do something like <cfloop query="q1"> #q1.ORDER_NUMBER#<br> </cfloop> <cfset lOrderNumber = ValueList(q1.ORDER_NUMBER)> <cfloop query="q2"> <cfif NOT ListFind(lOrderNumber,q2.ORDER_NUMBER)> #q2.ORDER_NUMBER#<br> </cfif> </cfloop> <cfset lOrderNumber = ListAppend(lOrderNumber,ValueList(q2.ORDER_NUMBER))> <cfloop query="q3"> <cfif NOT ListFind(lOrderNumber,q3.ORDER_NUMBER)> #q3.ORDER_NUMBER#<br> </cfif> </cfloop> ....
But it looks like you are retrieving the same data from the same table, so maybe you only need one query. Pascal > -----Original Message----- > From: Ian Littlefair [mailto:[EMAIL PROTECTED] > Sent: 26 November 2004 15:38 > To: CF-Talk > Subject: Re: Multiple Queries - Is this possible? > > Ok here are the six queries. I want > > 1)select ORDER_NUMBER, sub_zone > from ame_nemesis_ordrep > where week = '#url.week#' > and channel_driver >= 1 > and exists (select 'x' from nem_cds_summ ncs > where ncs.order_NO=ORDER_NUMBER > and css_database=sub_zone > and week = week_number > and visits is null) > order by sub_zone ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185445 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
