Hi all, The task at hand is to find a series of orphaned folders. I want to delete all folders in a certain directory which do not have a matching DB record.
I was wondering if this is possible (or accept any other tips): I have a 'query' which is the result of a cfdirectory action="list". I now would like to find any records in that query that do not exist in the resultset of a second query (this second one is a database query). Is there a way to combine these two queries to get a resultset that just holds those items which do not exist in the second query? I know i could loop and query each record but wondered if there's a more efficient way, maybe a query of two other queries? Cheers Stefan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328465 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4