>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]
