a server. I just made a small change to the where clauses of the second
2 queries and it ran on my IIS dev box. couldn't see exactly where the
error was on the code, it said line 0?
The first query should give you all the common files.
Patrick
<CFDIRECTORY action="" directory="C:\" name="Eng">
<CFDIRECTORY action="" directory="C:\inetpub" 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 3:30 PM
To: CF-Talk
Subject: Re: Read directory
And I need those filenames which are common on both directories.
>Thanks for your reply.
>
>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#">
>
>
>
>
>
>> _____
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
