Nope, nothing wrong with it. There may be a limit on the number of statements in a QoQ WHERE clause, though I don't know. I know the old Microsoft JET database engine used to have a logical limit of 40 statements in the WHERE clause. Just something to note if it bombs on 30,000 statements ...
---------------------------------------- From: "Stefan Richter" <ste...@flashcomguru.com> Sent: Monday, January 31, 2011 3:21 PM To: "cf-talk" <cf-talk@houseoffusion.com> Subject: Re: Query of query help I was trying something like this: <cfquery name="orphanRooms" dbtype="query"> select * from roomList WHERE name = 'x' <cfloop query="roomsDB">OR roomList.name = '#roomid#' </cfloop> </cfquery> I think I am getting somewhere with it. Anything inherently wrong with this? Stefan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341740 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
