Yes, QoQ will work here.
<!--- get your folders --->
<cfdirectory action="list" name="roomList" type="dir"
directory="#roomsDir#">
<!--- get the rooms from the DB --->
<cfquery datasource="#dsn#" name="roomsDB">
SELECT roomid
FROM rooms
</cfquery>
<cfoutput query="roomList">
<!--- loop through the folders and check against the rooms in the DB
--->
<cfquery dbtype="query" name="orphanRoom">
SELECT name
FROM roomsDB
WHERE roomid = '#name#'
</cfquery>
<cfif not orphanRoom.recordCount>
<!--- flag this as a room without a folder --->
</cfif>
</cfoutput>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:341725
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
