how can I read records in reverse order

[gargs]

I have written a small message board script in asp that uses an access database to store usernames and messages, there is also a date feild that is set to Now() to display the the date and time the message was posted (much like this site I suppose).

How do I list the records in descending date order?

It may be glaringly obvious, but please help...

Thanks in advance

 

[Mighty]

When you select the data from the database, just sort the data by date before you write it out.

e.g

set myRS = myConn.Execute "SELECT * FROM myTable SORT BY myDate DESC"

do while not myRS.EOF
Response.Write myRS("myDate&quot & myRS("user&quot & myRS("message&quot
myRS.MoveNext
loop

Something along those lines should work. Hope that helps.
Mise Le Meas,

Mighty

 

[gargs]

Thanks for the tip but now I'm getting an error.

This is the code I'm using

SQLstmt = "SELECT * FROM cd SORT BY date DESC"
Set rs = conn.Execute(SQLstmt)

This is the error I'm now getting

Microsoft JET Database Engine (0x80040E14)
Syntax error in FROM clause.
/forum/default.asp, line 131

Any Ideas??

 

[Mighty]

Sorry, my mistake. It should be:

SQLstmt = "SELECT * FROM cd ORDER BY date DESC"
Mise Le Meas,

Mighty

 

[gargs]

Nice...

Thanks man, all working now.