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]
