Classic ASP Discussion - Great Recordset Paging

Print Page | Close Window

Great Recordset Paging

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

Topic: Great Recordset Paging

Posted By: WebDever
Subject: Great Recordset Paging
Date Posted: 05 May 2004 at 9:54am

How do you set-up recordset paging like this:

http://www.dmxzone.com/index.asp?TypeId=25&CatId=661 - http://www.dmxzone.com/index.asp?TypeId=25&CatId=661

Cheerz :)

Replies:

Posted By: dpyers
Date Posted: 05 May 2004 at 12:01pm

Depends on if your using ADO (Access) or MS SQL. In MS SQL, you'd use a stored procedure. The basic concept is

count the total number of rows
Divide it by the number of links you want
Construct the links to pass start/stop numbers - or start roww/numbsr of records to retrieve - to a page that invokes the db through whatever method your DB supports, and formats the output.

-------------

Lead me not into temptation... I know the short cut, follow me.

Posted By: WebDever
Date Posted: 05 May 2004 at 12:22pm

Sorry, to be a pain but could you show me exactly how to do that

p.s. don't worry about showing me how to do it in MSSQL

Thanks again!!

Posted By: dpyers
Date Posted: 05 May 2004 at 12:49pm

Away from my code right now, so can'ts grab an example. Try asp101 or aspfaq. It's the kind of thing they would have examples for.

-------------

Lead me not into temptation... I know the short cut, follow me.

Posted By: WebDever
Date Posted: 06 May 2004 at 5:34am

Okay, thanks for ur help!