|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
October 15th, 2003, 02:30 AM
|
|||
|
|||
|
Problem with ordering of numbers (ORDER BY)
Hi
I have the following problem. I am retreiving chapternumbers from a database, and want to sort them in ascending order. Using the "ORDER BY fieldname ASC" works fine until i get subchapters. These subchapters are like this: 1.1 1.2 1.3a 1.3b etc... So far the sorting is fine. However, when i get ten or more subchapters like 1.10, 1.11, 1.12 etc, it seems to be registered like 1.1, and end up at the top like this: 1.1 1.10 1.11 1.12 1.2 1.3 etc.. Anybody that knows a solution to this problem. (My site is created with ASP)
|
|
#2
October 20th, 2003, 10:26 AM
|
||||
|
||||
|
try listing your chapter number like this as text
1.01 1.02 1.03 1.04 1.05 1.06 1.07 1.08 1.09 1.10
__________________
My brain cells are like a storm trooper's armor: useless
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Problem with ordering of numbers (ORDER BY) |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
