Generating Pages Dynamically

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 ?

 

Code:

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/features/mssql/article.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.

 

This will help you out http://www.stardeveloper.com/articles/display.html?article=2000071001&page=1

 

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".

 

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.

 

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