Hmmm... So you can loop a query within itself?
Rick > -----Original Message----- > From: Paul Ihrig [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 09, 2008 9:41 AM > To: CF-Talk > Subject: Re: QoQ question - left outer join > > found a fix! > > <cfquery name="getNEQnum" dbtype="query"> > SELECT getZMA.Material > FROM getZMA > WHERE (1 = 1 > <!--- Make sure the current record does NOT match any records in the B > query.---> > <cfloop query="getEQnum">AND getZMA.Material <> '#Material#'</cfloop>) > > from: http://www.bennadel.com/index.cfm?dax=blog:1074.viewcode&index=1 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303047 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
