|
| |
|
|
kitty6
Posts: 153
Joined: 10/15/2005
Status: offline
 |
sorting - 9/25/2007 11:31:54
I'm using the DRW to display results. I have a field which has numbers in it. I'm also sorting that so it displays assending. He is my question:
It displays 1, 10, 11, 13, 2, 21, 3, etc... How can I fix the sort so it displays 1, 2, 3, 10, 11, etc...?
Thanks.
|
|
|
|
ou812
Posts: 1602
Joined: 1/5/2002
From: San Diego
Status: offline
|
RE: sorting - 9/25/2007 12:24:39
It is looking like your column storing the numbers is a text field. If you can change it to a numeric field it should sort correctly.
_____________________________
-brian
EnterpriseDB: Enterprise-class relational database management system
PostgreSQL: The world's most advanced open source database
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
