How to make Pagination using ASP classic

Discussion in 'C#' started by okpara36, Sep 4, 2009.

0
  1. #1
    I have a table with more than 100 articles... category.asp
    I would like to show 10 by 10 please how can I do that..


    thank you
     
    okpara36, Sep 4, 2009 IP
  2. wacamoi

    wacamoi Peon

    Messages:
    810
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    0
    #2
    try may use

    n=0
    for n=n+1
    next

    to combine with the following scripts

    SQL= "select top 10 * from table_name order by field_name "

    SQL="SELECT TOP 20 * FROM (select top 30 * from TB order by datetime_field) TB order by datetime_field
     
    wacamoi, Sep 6, 2009 IP