Format number to count like a human in asp page

[Mick]

Sorry Group, I know Ive seen this one before but cant find the answer anywhere

I have a number field in asp results from an access database. Its producing
a list of results thus 1,11,111,2,21,211,3,31 etc , but I want it to count
like a human 1,2,3,4, etc. Can someone please steer me to the answer. Many
thanks.

 

[Stefan B Rusynko]

Explain "count like a human"
If you mean the database is to return the records having numbers (1,11,111,2,21,211,3,31)
sorted correctly as 1,2,3,11,21,31,111,211
- apply a sort criteria to your sql statement calling the DB results
(for example if the field is called say "myNumbers" the criteria would include "OrderBy myNumbers ASC")

Note:
To sort correctly your "myNumbers" DB field containing the records must be a numeric field (not a text field)



--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Sorry Group, I know Ive seen this one before but cant find the answer anywhere
|
| I have a number field in asp results from an access database. Its producing
| a list of results thus 1,11,111,2,21,211,3,31 etc , but I want it to count
| like a human 1,2,3,4, etc. Can someone please steer me to the answer. Many
| thanks.