This topic is locked

Sorting NUMBER BASE OR CHARATER BASE

7/23/2009 11:17:49 AM
PHPRunner General questions
O
obiekwe author

in my database When sorting on (sample height) number - the sorting is on character basis and not on number basis.

the problem that the numbers are treated as text and not as numbers?

There must be a way to have numbers formatted as numbers I do hope.

Example

http://demo.asprunner.net/obiekwe_kth_se/P...sample_list.php

(the password- admin, username -admin

in trying to sort the "Max Sample HeightZ(mm)"

30 > okay

but 30 < wrong

J
Jane 7/24/2009

Hi,
this error happens because these fields are set up as CHAR in your database.

To fix it set up these fields as numeric, then run PHPRunner, syncronize project and rebuild it.