So... is just the one variable, "Material", of the current loop iteration being used in the "where" clause?
But still... it seems like a "limited" loop of the query is being used. It seems as if the loop just "loops" over the one variable value for '#Material#'. The loop seems to be acting as a means of reading the value of '#Material#' for current query row. Would that be accurate? I've just never seen a loop of a query inside the query itself. Then, again, having just moved from CF 4.5 to CF 8, I've never used a QoQ, either! :o) Rick > -----Original Message----- > From: Dominic Watson [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 09, 2008 12:20 PM > To: CF-Talk > Subject: Re: QoQ question - left outer join > > > > > So you can loop a query within itself? > > > > The loop is just generating the QoQ SQL dynamically - once the SQL has been > 'generated' and parsed it then gets processed. So, in reality, the query is > not looped within itself. > > Dominic > > -- > Blog it up: http://fusion.dominicwatson.co.uk > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:303051 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
