Closed Thread Icon

Topic awaiting preservation: .mdb sorting problem? (Page 1 of 1) Pages that link to <a href="" title="Pages that link to Topic awaiting preservation: .mdb sorting problem? (Page 1 of 1)" rel="nofollow" >Topic awaiting preservation: .mdb sorting problem? <span class="small">(Page 1 of 1)</span>\

Paranoid (IV) Inmate

From: Lebanon
Insane since: May 2001

posted posted 08-21-2002 09:07


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 is the primary key.

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


Bipolar (III) Inmate

Insane since: May 2002

posted posted 08-21-2002 10:44

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
Maniac (V) Inmate

From: Switzerland
Insane since: Mar 2001

posted posted 08-21-2002 11:02

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


« BackwardsOnwards »

Show Forum Drop Down Menu