Are you storing the numbers as text or as a number in the database? If you are doing an "order by" and the numbers are being stored as text in the database the numbers will be sorted like words and not numbers.
On Thu, Apr 3, 2008 at 5:15 PM, Paul Ihrig <[EMAIL PROTECTED]> wrote: > it is not sorting this way... > i Want it to sort this way > > On Thu, Apr 3, 2008 at 4:55 PM, Ian Skinner <[EMAIL PROTECTED]> wrote: > > Paul Ihrig wrote: > > > 1 > > > 101 > > > 101010 > > > 2 > > > 201 > > > 202 > > > 201010 > > > 201020 > > > 3 > > > 302 > > > > This is an alphabetical order of numbers. Why the list is being order > > alphabetically I can not say without seeing some relevant code. But > the > > solution is to tell your code to treat this data a numerical data not > > character data. > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302663 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4