Ah great, an interesting approach. Many thanks. Stefan
On 31 Jan 2011, at 20:10, Jason Fisher wrote: > > Stefan, > > > This might work ... can't remember if the IN () function works in QoQ or > not. > > > <!--- get a list of all the rooms from the DB (after you query) ---> > > <cfset roomList = valueList(roomsDB.roomid) /> > > > <!--- now query to get folders that are not in the rooms DB list ---> > <cfquery dbtype="query" name="roomsOK"> > SELECT * > FROM roomList > WHERE name NOT IN ( <cfqueryparam cfsqltype="cf_sql_varchar" > value="#roomList#" list="true" /> ) > </cfquery> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:341738 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
