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 ?
0
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
0
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.
0
pradeep's Avatar, Join Date: Apr 2005
Team Leader
This will help you out http://www.stardeveloper.com/article...0071001&page=1
0
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".
0
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.
0
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