1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Generating Pages Dynamically

Discussion in 'ASP' started by Bhullarz, May 5, 2008.

  1. Bhullarz

    Bhullarz New Member

    Joined:
    Nov 15, 2006
    Messages:
    253
    Likes Received:
    13
    Trophy Points:
    0
    Occupation:
    System Manager
    Home Page:
    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 ?
     
  2. pradeep

    pradeep Team Leader

    Joined:
    Apr 4, 2005
    Messages:
    1,646
    Likes Received:
    86
    Trophy Points:
    0
    Occupation:
    Programmer
    Location:
    Kolkata, India
    Home Page:
  3. Bhullarz

    Bhullarz New Member

    Joined:
    Nov 15, 2006
    Messages:
    253
    Likes Received:
    13
    Trophy Points:
    0
    Occupation:
    System Manager
    Home Page:
    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.
     
  4. pradeep

    pradeep Team Leader

    Joined:
    Apr 4, 2005
    Messages:
    1,646
    Likes Received:
    86
    Trophy Points:
    0
    Occupation:
    Programmer
    Location:
    Kolkata, India
    Home Page:
  5. Bhullarz

    Bhullarz New Member

    Joined:
    Nov 15, 2006
    Messages:
    253
    Likes Received:
    13
    Trophy Points:
    0
    Occupation:
    System Manager
    Home Page:
    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".
     
  6. pradeep

    pradeep Team Leader

    Joined:
    Apr 4, 2005
    Messages:
    1,646
    Likes Received:
    86
    Trophy Points:
    0
    Occupation:
    Programmer
    Location:
    Kolkata, India
    Home Page:
    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.
     
  7. akshits

    akshits New Member

    Joined:
    May 10, 2009
    Messages:
    23
    Likes Received:
    2
    Trophy Points:
    0
    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
     

Share This Page