I'm trying to get the proper order of the directories. Bascially don't list the directories/files as case sensitive.
I'm running the following query:
<cfftp action="" stoponerror="no" name="rootfiles" directory="#url_dir#" connection="test">
<cfquery name="dirlisting" dbtype"query">
SELECT IsDirectory, Name
FROM RootFiles
ORDER BY IsDirectrory DESC, Name
</cfquery>
<cfloop query="DirListing">
#name#
</cfloop>
The code above will run but when I add this line I get an error LOWER(ISDIRECTORY) is no a column that can be sorted on.
ORDER BY lower(IsDirectory) DESC, IsDirectory DESC, Name
Why don't I get this error with ORDER BY IsDirectrory DESC, Name???
Is not sorting this also?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
