|
devshb
Senior Member
United Kingdom
1904 Posts |
 Posted - September 29 2008 : 05:08:04
|
They're ordering in that way because it's a text/character field, so, for example:
10
comes before
2
(because the first character "1" is before "2")
If you want to order it in a numerical way, then there are 2 ways to do it:
1) Add a new value to a number column which is a copy of the oz value but just numeric eg use price2 to hold something like:
1
2
10
etc
or:
2) Add a left-padded-with-zeroes value to a character column which is a copy of the oz value but just numeric eg use pother2 to hold something like:
001
002
010
etc
and then (whichever of the above you use), add that column for your ordering config option.
Simon Barnaby
Developer
[email protected]
www.BigYellowZone.com
Web Design, Online Marketing and VPASP addons |
 |
|
All Forums
Numeric Ordering of subproducts
New Topic
Printer Friendly
Topic 
TrustGuard - PCI Security Scanner
