Generating Pages Dynamically

Bhullarz's Avatar
Skilled contributor
How ca we generate number of pages dynamically while we are fetching data from the MS-Access database ? Like I have one asp page which is fetching a number of rows from the access database. I want to restrict per page entries to 20 only and rest are to be displayed in next pages. I have read somewhere that Recordset can be use to divide the data in Pages. Like one property is Pagecount and another is Pagelength. But I dont remember the usage. Can anybody help me in this ?
pradeep's Avatar, Join Date: Apr 2005
Team Leader
Code: SQL
SELECT TOP 1000 posts.* FROM posts
This will select the top 1000 records from the DB, read more about TOP here http://www.databasejournal.com/featu...le.php/3532226
Bhullarz's Avatar
Skilled contributor
Quote:
Originally Posted by pradeep
Code: SQL
SELECT TOP 1000 posts.* FROM posts
This will select the top 1000 records from the DB, read more about TOP here http://www.databasejournal.com/featu...le.php/3532226
Bro! I am talking about RECORDSET..used in ASP. I have fetched the data in RECORDSET. Now I want to display the records as they are arranged in different pages whereas we are generating those dynamically.
pradeep's Avatar, Join Date: Apr 2005
Team Leader
This will help you out http://www.stardeveloper.com/article...0071001&page=1
Bhullarz's Avatar
Skilled contributor
CAn u help me to retrieve the data in backward manner like from 10 the post to first post. I tried it,but it says recordset doesn't support backward fetching. Can u tell me which kind of cursor support backward fetching as I am using ASP with MS Access 2000. I think by default, the cursor type is "ForwardOnly".
pradeep's Avatar, Join Date: Apr 2005
Team Leader
Keyset Cursor (adOpenKeyset – 1). It is similar to the Dynamic Cursor above except hat it does not allow access to records added by other users. It allows all types of movements through the recordset.
akshits's Avatar, Join Date: May 2009
Go4Expert Member
You can use the following SQL statement on the page:-

SELECT * FROM TABLE WHERE WHATEVER LIMIT INDEX, COUNT

Check the code out.

SELECT * FROM **** WHERE ******** LIMIT 0, 20 1ST PAGE
SELECT * FROM **** WHERE ******** LIMIT 19, 20 2ND PAGE

Regards,
Akshit Soota