Classic ASP Discussion - Displaying records in reverse order

Print Page | Close Window

Displaying records in reverse order

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=8722
Printed Date: 01 April 2026 at 1:12am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Displaying records in reverse order

Posted By: worldwide1504
Subject: Displaying records in reverse order
Date Posted: 09 January 2004 at 7:00pm

I have this I used from the guestbook tutorial:


'Loop through the recordset
Do While not rsNews.EOF
     
     display record 1
     display record 2
     etc.

     'Move to the next record in the recordset
     rsNews.MoveNext
Loop

How would I make it go

etc.
record 2
record 1

Replies:

Posted By: michael
Date Posted: 09 January 2004 at 7:24pm

Change the sortorder of the sql statement
select col1,col2, ... from tablename ORDER by columntosortby DESC

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: worldwide1504
Date Posted: 09 January 2004 at 7:57pm

Ok great.
Thanks alot.