File names not correctly ordered

[Mark Henderson]

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]

---