Recordset Paging with 4000+ Records

[MicroBlueChip]

Hi All,

I am currently coding a search mechanism for a store which has 4000+ items. However I currently have only "previous page" and "next page" links in order to navigate through the results which is painful for the customer to use.

How can I go about using paging. I have found lots of example code but this only works on a per page basis and therefore this would create 400 page links on a 10 records per page basis. Are there more efficient and better ways for performing Recordset paging with excess of 4000+ records.

Many Thanks
Phil.

 

[bjgrem]

What you might want to do is create a "order by" variable so that your customers can select in what order they want the records to be displayed.

eg:

strSQL = "Select * from Table where * = * Order By" & Request.Querystring("sort&quot - "sort" being the name of your drop-down box.

 

[MicroBlueChip]

Thanks bjgrem.

I am already sorting by price (both ascending or descending depending on choice by the user. The client still wants the page numbers at the bottom. What about like on this forum i.e. only shows 10 pages and then the next 10 pages etc.

Phil.