<CFQUERY dbtype="query" name="f_notin_e">
select UPPER(name) as fsort, * from eng1
where eng1.name in ('#replace(valuelist(fre1.name), ",", "','","all")#')
ORDER by fsort ASC
</CFQUERY>
is that right?????
> one more thing I have to resove in this issue is I need those filename
> sorted alphabetically.
>
> 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]
