I am actually getting and error
Query Of Queries syntax error.
Encountered "e" at line 0, column 0.
The error occurred in C:\Inetpub\wwwroot\first\petro.cfm: line 9
7 : <CFDIRECTORY action="" directory="#french1#" name="Fre">
8 :
9 : <CFQUERY dbtype="query" name="common">
10 : select * from eng e, fre f
11 : where f.name = e.name
These are the current codes.
------------------------------
<CFDIRECTORY action="" directory="#english1#" name="Eng">
<CFDIRECTORY action="" directory="#french1#" 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>
<cfdump var="#e_notin_f#">
<cfdump var="#common#">
>Assuming ColdFusion 5 or better you can indeed use the cfdirectory
>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]
