I haven't used Q of Q very much, but SQL for something like that would be:
<cfquery>
SELECT a.name As MissingFilesFromDir1, b.name As MissingFilesFromDir2
FROM cfDir1 a FULL OUTER JOIN cfDir2 b
ON a.name = b.name
WHERE a.name IS NULL or b.name IS NULL
</cfquery>
You may want to prefix the a.name and b.name with the respective directory
path. Then you can use ValueList to pull all the missing ones in each
directory.
Make sense? Or maybe I'm way off.
Ben Johnson
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
