Sorry, I mis-spoke (hazard of using a word with double meanings). I need to sort the results of a query in this way.
> -----Original Message----- > From: Everett, Al [mailto:[EMAIL PROTECTED]] > Sent: January 22, 2003 5:04 PM > To: CF-Talk > Subject: RE: Sorting Numbers > > > What you've got there is an ASCII sort. > > You want a numeric sort. > > ListSort(myList,"numeric") > > > -----Original Message----- > > From: Jillian Carroll [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, January 22, 2003 5:51 PM > > To: CF-Talk > > Subject: Sorting Numbers > > > > > > How do I sort a list so that it doesn't do this: > > > > 1 > > 2 > > 3 > > 4 > > 5 > > 6 > > 7 > > 8 > > 9 > > 10 > > 100 > > 101 > > 102 > > 103 > > 104... > > > > I want 11 to come after 10. > > > > Thanks! > > > > -- > > Jillian > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4