Problem with paging search results correctly

[Chris Hohmann]

"CharitiesOnline" <charitiesonline@hotmail.com> wrote in message
news:IaCqb.179$u03.28@news-binary.blueyonder.co.uk...

> Hello,
> I have set this script up to add paging to a search results page.

Which on

> the first page works fine. I calculates how many pages there should be
> depending on the number of results returned from my search and how

many

> records I have set it to display per page. All great so far,

HOWEVER.....

>
> When you click the next link to see the next 10 results on the next

page, it

> just dumps the search details and pulls up all the records in the

table! So

> it finds 320 matching results, and then happily pages through them 10
> records at a time, with both the next and prev links working!
>
> I need to find a way of using this paging system in conjunction with

the

> search results, so if for example I search for "yellow" and I get 18
> matching results with the first 10 being displayed on the first page,

& I

> then click next, I would like to see the last 8 results on the next

page,

> with the option to click 'prev' and see the previous 10 again. What

actually

> happens is that it shows me the first 10 matching results and says
> displaying page 1 of 2, I click the 'next' link and it suddenly says

showing

> page 2 of 32 and starts listing all the records from the database

starting

> at record number 11 !
>
> Please can anyone help me fix this?

Please don't multi-post

Newsgroup Etiquette:
aspfaq.com/2081


Recordset Paging:
aspfaq.com/2120

HTH
-Chris Hohmann

[Chris Hohmann]

And now for an answer to your actual question... :)

The problem is that the search criteria is not being passed along when
you page through the recordset. You're code is looking for
Reuqest.Form("seach"). Therefore you must either

1. Replace your previous/next links with a form that passes the search
criteria.

OR

2. Include the search criteria in the links and modify your code to
check for both Request.Form("search") and Request.Querystring("search")


HTH
-Chris