Classic ASP Discussion - Soring Database Enteries (Down to up)

Print Page | Close Window

Soring Database Enteries (Down to up)

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=13423
Printed Date: 30 March 2026 at 9:21pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Soring Database Enteries (Down to up)

Posted By: neotrix
Subject: Soring Database Enteries (Down to up)
Date Posted: 19 January 2005 at 2:06pm

Originally posted by In my source code I

In my source code I wrote:

rspage.MoveLast
While NOT rspage.BOF

' ... do something...

rspage.MovePrevious

wend

===============================================

This is the only soulution that comes to my mind for print the records of a table from bottom to top. But it results this:

My IIS wrote:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E24)
Rowset does not support fetching backward.
/neotrix/Control_Room/default.asp, line 38

-------------
http://www.muhammadbinyusrat.com/blog/" rel="nofollow - Say to the believing men..

Replies:

Posted By: dj air
Date Posted: 19 January 2005 at 2:48pm

why do you want to do it back wards like that. why not use the ORDER BY xx DESC;

Posted By: neotrix
Date Posted: 19 January 2005 at 3:14pm

Actually, I am making a blog type thing. When ever I make a new post, I want it to be printed on the top. Instead, it appears on the bottom of the page. And I donot understand what "ORDER BY xx DESC;" means.

-------------
http://www.muhammadbinyusrat.com/blog/" rel="nofollow - Say to the believing men..

Posted By: dj air
Date Posted: 19 January 2005 at 3:26pm

does each blog entry has a unique ID (auto number).

if so you can add this to the end of the query



ORDER BY tablename.field DESC;

tablename = the table the blog is in.

field = the auto Field/Unique value

DESC= order them from newest to oldest .

Posted By: neotrix
Date Posted: 19 January 2005 at 3:31pm

yep it dose have a uniqe ID. Hold on let me try it.

-------------
http://www.muhammadbinyusrat.com/blog/" rel="nofollow - Say to the believing men..

Posted By: neotrix
Date Posted: 19 January 2005 at 3:35pm

yeyyy!!!!!!!!!!!!!!!!!!!

it worked!!!!

Wooho!!!

Thanks Sir!!! You're the best!

-------------
http://www.muhammadbinyusrat.com/blog/" rel="nofollow - Say to the believing men..