Post reply

displaying data by pages

  • April 23, 2003 at 1:46 am

    #160092

    hello....

    I am assigned to display data on a web page by filtering to display only 50 data. meaning if I have 150 data, I need to display it in 3 pages, Can anyone help me??

    I am using ASP codings...thanks

    eat when you can and not when you cannot.


    eat when you can and not when you cannot.

  • April 23, 2003 at 2:01 am

    #454998

    A couple of ideas depending on how much data there is.

    1. In the ASP, use GetRows to put the entire recordset into an array. Then loop through array from 0 or 50 or 100 based on which page you are on (1,2,3). This will work OK for a few hundred rows.

    2. For larger recordsets, use an Identity field and a start value to return the top 50 rows where identity >= start value ordered by identity.

    Jeremy

  • April 23, 2003 at 2:17 am

    #455001

    Depends on how static the data is and whether you create the recordset on each pass or not.

    If you are using ADO you can use PageSize, PageCount and AbsolutePage to move through the recordset.

    Far away is close at hand in the images of elsewhere.
    Anon.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply