Professional Web Applications Themes

Pagination? - ASP Database

I think that's the term I need! I have a database of 48,000 products. They have been divided up into 41 categories and about 1300 subcategories. I am using Frontpage 2000s DRW (database results wizard) to display the "search results" for each category. I made 41 pages - each one will display records from a query for that category. Some categories have 1000s of records. Frontpage calls all the records in the query, and shows something like page 1 of 247, with a previous and next button. I'd like to have something done in asp that would show the pages ...

  1. #1

    Default Pagination?

    I think that's the term I need!

    I have a database of 48,000 products. They have been divided up into 41
    categories and about 1300 subcategories.

    I am using Frontpage 2000s DRW (database results wizard) to display the
    "search results" for each category. I made 41 pages - each one will display
    records from a query for that category. Some categories have 1000s of
    records.

    Frontpage calls all the records in the query, and shows something like page
    1 of 247, with a previous and next button.

    I'd like to have something done in asp that would show the pages like:

    [1] [2] [3] [4] etc

    and call only one page's worth at a time, to conserve server/database load.

    And also, I'd like to go from the main category page to subcategory pages,
    and then on to the results page for each subcat. With the same 1, 2, 3, 4
    paging.

    Does anyone either know of a script or program, simple enough to set up for
    someone who knows very, very, VERY little asp, or is there anyone here who
    could do this for a fee? A not-too-awfully-much fee, cuz I'm poor right now!

    Thanks,

    JA



    JA Guest

  2. #2

    Default Re: Pagination?

    Please consult www.google.be first before you ask newsgroup

    http://www.asp101.com/articles/recordsetpaging/index.asp


    John Guest

  3. #3

    Default Re: Pagination?

    http://www.aspfaq.com/2120

    --
    http://www.aspfaq.com/
    (Reverse address to reply.)




    "JA" <rr.com> wrote in message
    news:VTu0d.9038$rdc-kc.rr.com... 
    display 
    page 
    load. 
    for 
    now! 


    Aaron Guest

Similar Threads

  1. Book Pagination (.indb) Continuous Pagination (HELP!)
    By David_G_Wolf@adobeforums.com in forum Adobe Indesign Macintosh
    Replies: 12
    Last Post: September 21st, 01:14 PM
  2. Pagination
    By Emilie_Giguere@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 1
    Last Post: September 20th, 07:45 PM
  3. Pagination help?
    By Renee_Tanner@adobeforums.com in forum Adobe Indesign Macintosh
    Replies: 5
    Last Post: July 17th, 01:26 PM
  4. Pagination?
    By Thomas_001 in forum Macromedia Flex General Discussion
    Replies: 2
    Last Post: August 18th, 04:39 PM
  5. Pagination with CF
    By Daniel Eng in forum Coldfusion - Advanced Techniques
    Replies: 8
    Last Post: June 7th, 03:35 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139