Posted - September 29 2008 : 05:08:04
| They're ordering in that way because it's a text/character field, so, for example:
(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:
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:
and then (whichever of the above you use), add that column for your ordering config option.
Web Design, Online Marketing and VPASP addons