It's not working that way... it does: 1, 10, 100, etc. instead of 1, 2, 3, 4, and so on.
> -----Original Message----- > From: Ewok [mailto:[EMAIL PROTECTED]] > Sent: January 23, 2003 8:24 AM > To: CF-Talk > Subject: Re: Sorting Numbers > > > if the field's data type in the table is numeric then you can > just order your query by that field? > > ----- Original Message ----- > From: "Jillian Carroll" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, January 22, 2003 6:24 PM > Subject: RE: Sorting Numbers > > > > 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
