1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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