I try to use the ORDER BY eng1.name ASC
but in the middle of the page somewhere its finished on 'Z' and then start again from 'A' (that start is unique, i.e. not repeating).
I don't know where I am doing wrong, also could you please mentioned that which query should I output to get the filenames which are in both directory?
<cfset english = "C:\output\eng">
<cfset french = "C:\output\fre">
<CFDIRECTORY action="" directory="#english#" name="Eng1" sort="name">
<CFDIRECTORY action="" directory="#french#" name="Fre1" sort="name">
<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 in ('#replace(valuelist(fre1.name), ",", "','","all")#')
ORDER by eng1.name ASC
</CFQUERY>
<CFQUERY dbtype="query" name="e_notin_f">
select * from fre1
where fre1.name in ('#replace(valuelist(eng1.name), ",", "','","all")#')
ORDER by fre1.name ASC
</CFQUERY>
and then I output the query "f_notin_e" ( I've dump both and it looks both are generating the same output i.e. "f_notin_e" & "e_notin_f"
please advise that which query should I output and the filenames are not sorted.
thanks
> Thank alot for help.
> it was a map drive and I was trying to access that directory from my
> local machine, in that case the structure was empty.
> When I put the codes on server(then it becomes a local drive) and it
> gave me the required output.
>
> thanks once again.
> -
Asim
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
