This topic is locked

Sorting 9 before 10...

5/28/2007 5:59:16 PM
PHPRunner General questions
R
run4sbc author

So I use this software to create online databases for sports, mostly track and field. In track, a 9.79 second 100 Meter Dash is faster than a 10.01 but everything always sorts by the first digit....I was just curious if there was any way of fixing this. I know it would have to be complicated because it deals with decimals and whatnot. It also does the same thing for a 9:59 and a 10:00...any help would be appreciated.
Cody

Alexey admin 5/29/2007

Cody,
looks like your field has VARCHAR type.

Change it to DECIMAL on Datasource table tab in PHPRunner or using any database management software.