var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Sort Problem
I have a soring problem. For example, when I sort I get the follwoing: Any Idea how to fix this sort???
Thanks in Advance
These numbers are string. cOnvert them to integer or real numbers then sort
What's your data type? If it's text it will sort the way you've shown. If it's number, it should sort correctly.
Or you can check this website out.
Originally Posted by markwaugh
The resulting recordset is:
SELECT CLng([Field1]) AS LongField1
ORDER BY CLng([Field1]);
See the CLng() function in the Help for details.
using an explicit number conversion like cint / clng shoudl od the job, but lets face it it's still a kludge.
The basic point is that the data type used for storage should match the data itself, anything else is asking for problems later on down the line.