Ray Camden's Friday Puzzler - Compare Directories

<!--- Query files from directory A. --->
<cfdirectory
	action="list"
	directory="#ExpandPath( './A/' )#"
	name="qA"
	/>


<!--- Query files from directory B. --->
<cfdirectory
	action="list"
	directory="#ExpandPath( './B/' )#"
	name="qB"
	/>


<!--- Query for files that are in A, but not in B. --->
<cfquery name="qAOnly" dbtype="query">
	SELECT
		[name]
	FROM
		qA
	WHERE
		[type] = 'File'
	AND
		(
				1 = 1

			<!---
				Make sure the current A record does NOT
				match any records in the B query.
			--->
			<cfloop query="qB">

				AND
					[name] != '#qB.name#'

			</cfloop>
		)
</cfquery>


<!--- Query for files that are in B, but not in B. --->
<cfquery name="qBOnly" dbtype="query">
	SELECT
		[name]
	FROM
		qB
	WHERE
		[type] = 'File'
	AND
		(
				1 = 1

			<!---
				Make sure the current B record does NOT
				match any records in the A query.
			--->
			<cfloop query="qA">

				AND
					[name] != '#qA.name#'

			</cfloop>
		)
</cfquery>


<!---
	Query for files that are both in A and B, but not
	on the same date or size.
--->
<cfquery name="qBoth" dbtype="query">
	SELECT
		qA.[name]
	FROM
		qA,
		qB
	WHERE
		qA.[type] = 'File'
	AND
		qA.[name] = qB.[name]
	AND
		(
				qA.datelastmodified != qB.datelastmodified
			OR
				qA.size != qB.size
		)
</cfquery>



<!--- Dump out results. --->
<cfdump
	var="#qAOnly#"
	label="Directory A Only"
	/>

<br />

<cfdump
	var="#qBOnly#"
	label="Directory B Only"
	/>

<br />

<cfdump
	var="#qBoth#"
	label="Both But Different"
	/>