Topic awaiting preservation: .mdb sorting problem? (Page 1 of 1)

Hello,

I have an ASP script that queries an access DB.

I do this query SELECT * FROM mytable ORDER by lineno

where mytable.lineno is a numeric field and mytable.id is the primary key.

instead of the result getting sorted, it gets sorted randomly!

why?

there's no reason for this happening as far as I can see

without knowing more about the database and your local settings, the only thing I can think of is that it's attempting to do an order by on the ascii values of the lineNo value instead of treating it as a numeric value

not much help, but it might be a place to start from
I:.

without knowlegde about access...can you
sort in ASC or DESC like in mysql?

cu
~Xdreamer.ch~