Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 5th, 2005, 01:19 AM
Friend of Wrox
 
Join Date: Jul 2004
Posts: 240
Thanks: 0
Thanked 1 Time in 1 Post
Default Paging recordsets

Let's say you have pages 1 | 2 | 3 | 4 | 5 and you're on page 3. How do you make the code so that 3 will be without url?

Learning of our true origins.

I feel sorry:

http://www.infowars.com/articles/wor...eknowledge.htm

Foreknowledge of A Natural Disaster
Washington was aware that a deadly Tidal Wave was building up in the Indian Ocean
 
Old January 5th, 2005, 04:27 AM
Friend of Wrox
 
Join Date: Sep 2004
Posts: 104
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to sureshbabu Send a message via Yahoo to sureshbabu
Default

Hi,
     Here you can use the "AbsolutePage" which is a Recordset property.It is as follows..
In the loop while displaying pages ..use if condition..like..
If RecordsetName.AbsolutePage = currentPage Then
         Response.write currentPage
Else
         Response.write "<a href=Pagename&PageNo=" & currentPage & ">" & currentPage & "</a>"

End If

Thanks
Suresh
 
Old January 5th, 2005, 05:26 AM
Friend of Wrox
 
Join Date: Dec 2004
Posts: 307
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Vadivel Send a message via Yahoo to Vadivel
Default

Extract from asp101:

There are five different recordset properties that are used to implement recordset paging:
CursorLocation :: In order to use recordset paging, you will need to set this value to "adUseClient".

PageSize :: Sets the number of records that the recordset will display on each page. A neat use of this is to allow the client to configure this setting so that they can tailor the recordset to their tastes.

PageCount :: After setting the recordset's PageSize, you can read this property to check how many pages are in the recordset.

AbsolutePage :: This property tells you what page you are on. You can set this property on the fly to jump to a different page in the recordset.

AbsolutePosition :: This property will tell you what record you are on. You can read this property, or write to it to jump to a specific record.

You can go through the full article here :: http://www.asp101.com/articles/recor...ging/index.asp (it has code samples in it)

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com





Similar Threads
Thread Thread Starter Forum Replies Last Post
DB recordset paging using ajax paging? kumiko Classic ASP Basics 0 May 26th, 2008 10:23 AM
Paging Through Recordsets tuffour Classic ASP Databases 1 August 10th, 2004 01:57 PM
Paging through Recordsets - Please Help buckster Classic ASP Databases 4 May 7th, 2004 07:57 AM
Paging Recordsets Sparky Classic ASP Databases 3 April 13th, 2004 05:01 AM
Recordsets bph Access VBA 17 February 17th, 2004 03:19 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.