2. PHPRunner General questions
  3. phprunner 5.0 : problem with number descending mode
This topic is locked

phprunner 5.0 : problem with number descending mode

 		7/22/2010 1:20:31 PM
PHPRunner General questions
S
 sadisticmagician author

Hello, i have a problem.

In my database I have a table with code, with setting 'text field', why my code are not only numbers, but contains letters in this mode:
my code are in descending mode:

3

2

2/B

1
the problem is when my code is number 100 or 1000

if i have

1000

1000/b

100
my sequence of number is:

999

998

100

1001 <---this is problem

1000/b

1000
but i want this sequence:

1001

1000/b

1000

999

998

100

99
if i write code in this mode, i not have problem but is very long work.

00099

00100

00101
thanks all for help me!
J
 		Jane 7/23/2010

Hi,
values in the text field are sorted as text, not as numbers.

Unfortunately there is no way to sort records by numbers with these values. You can re-save values as 00099, 00100, etc. or change field type to number for this field.
S
 		sadisticmagician author 7/23/2010



Hi,
values in the text field are sorted as text, not as numbers.

Unfortunately there is no way to sort records by numbers with these values. You can re-save values as 00099, 00100, etc. or change field type to number for this field.


Ok <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=51386&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' /> thanks jane for response me.