Classic ASP Discussion - Order of Reading Records

Print Page | Close Window

Order of Reading Records

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=7795
Printed Date: 31 March 2026 at 11:22pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Order of Reading Records

Posted By: WookMaster
Subject: Order of Reading Records
Date Posted: 02 December 2003 at 12:14pm

I have an ASP page that reads through the records in an access database using the Do While Not .EOF

How would I go about starting from the end of the file and going to the beginning. I would like to display the newest added items first, I could either sort by date or since access adds records in numerical order, start from the end of the table and go to the beginning. If you have any ideas or links to referenced I appreciate it. Thanks

Replies:

Posted By: Mart
Date Posted: 02 December 2003 at 12:21pm

SELECT * FROM [table] ORDER BY ID DESC;< ="">

Posted By: WookMaster
Date Posted: 02 December 2003 at 5:57pm

thanks worked great