#french1# and #english1#
make sure you're searching in the right places..
On Mon, 13 Sep 2004 15:49:06 -0400, Asim Manzur
<[EMAIL PROTECTED]> wrote:
> It looks like something wrong.
> If I just cut/paste the code, it gives me the error I mentioned earlier on tablename alias. so I removed that.
>
> now there is no error, but the structure is blank, there is no value on it, and I made sure that there are 150 files in the folder.
>
> <CFDIRECTORY action="" directory="#english1#" name="Eng1">
> <CFDIRECTORY action="" directory="#french1#" name="Fre1">
>
> <CFQUERY dbtype="query" name="common">
> select * from eng1, fre1
> where fre1.name = eng1.name
> </CFQUERY>
> <CFQUERY dbtype="query" name="f_notin_e">
> select * from eng1
> where eng1.name not in ('#replace(valuelist(fre1.name), ",", "','","all")#')
>
> </CFQUERY>
>
> <CFQUERY dbtype="query" name="e_notin_f">
> select * from fre1
> where fre1.name not in ('#replace(valuelist(eng1.name), ",", "','","all")#')
>
> </CFQUERY>
>
> <cfdump var="#e_notin_f#">
> <cfdump var="#Eng1#">
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
