sorting by number field?

Results 1 to 2 of 2

Thread: sorting by number field?

  1. #1
    Join Date
    Dec 1969

    Default sorting by number field?

    any solutions on this? when I sort a field by number is comes up like this:<BR><BR>1<BR>1<BR>100<BR>15<BR>15<BR>150<BR>2 <BR>2<BR>20<BR>20<BR><BR>when it should go<BR><BR>1<BR>1<BR>2<BR>2<BR>10<BR>15<BR>100<BR>1 50<BR><BR>etc<BR><BR>Thanks for the help :)<BR><BR>dep<BR>

  2. #2
    Join Date
    Dec 1969

    Default Because

    You have numbers stored as text, and not as a number field. Switch your db field to type int, and your sort will work fine.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts