action list then a query of queries to compare the 2 result sets. Not
sure exactly what comparison you are trying to do, but the below code
will give you files common to both, files in fre that aren't in eng and
files in eng that aren't in fre.
<CFDIRECTORY action="" directory="C:\Eng" name="Eng">
<CFDIRECTORY action="" directory="C:\Fre" name="Fre">
<CFQUERY dbtype="query" name="common">
select * from eng e, fre f
where f.name = e.name
</CFQUERY>
<CFQUERY dbtype="query" name="f_notin_e">
select * from eng e
where e.name not in ('#replace(valuelist(fre.name, ",", "','","all")#')
</CFQUERY>
<CFQUERY dbtype="query" name="e_notin_f">
select * from fre f
where f.name not in ('#replace(valuelist(eng.name, ",", "','","all")#')
</CFQUERY>
Patrick McGeehan
Applications Developer
DIT
<CF_DIT>#mcg#</CF_DIT>
-----Original Message-----
From: Asim Manzur [mailto:[EMAIL PROTECTED]
Sent: Monday, September 13, 2004 2:39 PM
To: CF-Talk
Subject: Read directory
I have two directories.
C:\Eng
C:\Fre
The filenames are same on both dir. what I need to do is, Have to read
the files on both directories, check if the file exist on both folder,
then sort it ASC
and display it with <img> tag.
how can I acheive this. I think I have to use the <cfdirectory
action="" something like that but got no idea that how do I compare
and then stack for sorting and then display.
appriciate your help
thanks
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
