Go4Expert

Go4Expert (http://www.go4expert.com/)
-   ASP (http://www.go4expert.com/forums/asp/)
-   -   Generating Pages Dynamically (http://www.go4expert.com/forums/generating-pages-dynamically-t10389/)

Bhullarz 5May2008 05:10

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 ?

pradeep 5May2008 10:49

Re: Generating Pages Dynamically
 
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 5May2008 22:25

Re: Generating Pages Dynamically
 
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 6May2008 10:12

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

Bhullarz 8May2008 02:14

Re: Generating Pages Dynamically
 
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 8May2008 10:29

Re: Generating Pages Dynamically
 
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 10May2009 12:16

Re: Generating Pages Dynamically
 
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


All times are GMT +5.5. The time now is 06:24.