Closed Thread Icon

Topic awaiting preservation: .mdb sorting problem? (Page 1 of 1) Pages that link to <a href="https://ozoneasylum.com/backlink?for=12375" 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>\

 
lallous
Paranoid (IV) Inmate

From: Lebanon
Insane since: May 2001

posted posted 08-21-2002 09:07

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?

someoneInverse
Bipolar (III) Inmate

From:
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
I:.

Xdreamer.ch
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?

cu
~Xdreamer.ch~

« BackwardsOnwards »

Show Forum Drop Down Menu