[Bhullarz]

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]

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]

Quote:

Originally Posted by pradeep

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]

This will help you out http://www.stardeveloper.com/article...0071001&page=1

[Bhullarz]

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]

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]

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