2. ASPRunnerPro General questions
  3. Problem With Sorting Order
This topic is locked

Problem With Sorting Order

 		9/20/2007 4:24:55 PM
ASPRunnerPro General questions
L
 larryreed author

I have a site were teams enter their game scores for the league they play. I have noticed when I click on the column for the scores to sort from highest to lowest or visaversa, it apprears to only recoginize the first digit in the score. In a case where there is a score in the double digit, example 13 would be considered a lower number then say the score of 5 because it only appears to recoginize the first digit (1) in the number 13 . Is this a bug? Has anyone else experienced similar scenario?
P
 		Philip 9/20/2007

Is it possible that your db field is defined as text (instead of number) ?
L
 		larryreed author 9/21/2007

Is it possible that your db field is defined as text (instead of number) ?


Ah, that is a strong possibility.....I will check. I do believe it is text now that I think about it. Many Thanks for the reply. Larry