¿ªÔÆÌåÓý

Re: Database row sorting


 

Mick,

Clicking on the column headings does move the rows but they still do
not sort in numerical order.
If you mean you have many rows with a number in a particular column, when you sort on that column you're probably seeing an alphanumeric sort (1, 10, 11, 2, 3, 4, 5, 6, 7, 8, 9) instead of a numeric sort. The only fix for that I know of is to use leading zeros on your numbers (01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11).

The better solution would be to change the column type to Numeric. But that isn't an available option.

Shal


--
Help: /static/help
More Help: /g/GroupManagersForum/wiki
Even More Help: Search button at the top of Messages list

Join [email protected] to automatically receive all group messages.