contains the portion after the _ then using query of queries to sort by
that.
_____
From: Mark Henderson [mailto:[EMAIL PROTECTED]
Sent: Friday, 24 September 2004 3:53 p.m.
To: CF-Talk
Subject: File names not correctly ordered
hrmm..I just noticed in my output after a directory query, when displaying
files it orders them as follows...
file_1
file_10
file_2
file_20
file_3
etc etc,
instead of the preferred
file_1
file_2
file_3
file_10
file_20
I know how to correct this when dealing with *just* numeric info, but not
with letters and numbers.
My queries are pretty straightfoward...
<cfdirectory
name="getAllFiles"
action=""> directory="#serverdir##docpath#"
sort="name ASC">
<cfquery dbtype="query" name="getAllFiles_#docpath#">
SELECT *
FROM getAllFiles
</cfquery>
Any ideas on how to sort this out??
Regards
Mark H
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
