Forums

This topic is locked

Paging Recordset Problem with search results

Posted 06 Mar 2003 15:27:30
1
has voted
06 Mar 2003 15:27:30 Gil Ben-Horin posted:
Hi there,
I have created a search page for my database and also created a results page.
When trying to use the show next record, previous record behaviours on the results - the results page initally shows up ok.
However clicking 'next' to display the next 10 records results in 0 records on the next page.

The record paging functions work fine on a straight recordset without input from a search form.

Has anyone come across this problem in Dreamweaver and if so, is there any way around it?

Thanks

Replies

Replied 06 Mar 2003 19:14:47
06 Mar 2003 19:14:47 Owen Eastwick replied:
No code, so it's difficult to say and we don't even know what language you're using.

However, if this applies and you're using ASP, you could try this:

Use Request("textboxName" rather than Request.Form("textboxName"

Regards

Owen.

-------------------------------------------------------------------------------------------
Used programming books and web development software for sale (UK only): www.tdsf.co.uk/tdsfdemo/Shop.htm

Developer services and tutorials: www.drdev.net

Multiple Parameter UD4 / Access 2000 Search Tutorial: www.tdsf.co.uk/tdsfdemo/
Replied 06 Mar 2003 20:40:33
06 Mar 2003 20:40:33 Gil Ben-Horin replied:
Oops - completely forgot to mention I was using ASP.....

But guess what - you hit the nail right on the head! It works great now!!

Thank you so much.

Just out of curiosity, how come the request.form was causing so much trouble in the SQL query?

Thanks again!
Replied 06 Mar 2003 22:04:58
06 Mar 2003 22:04:58 Owen Eastwick replied:
To be honest I'm not sure of the exact technical explanation for this, or why and how long a value retrieved with Request("Whatever" will be available, but Request.Form, will allways look for a form from which to retrieve a value.

Regards

Owen.

-------------------------------------------------------------------------------------------
Used programming books and web development software for sale (UK only): www.tdsf.co.uk/tdsfdemo/Shop.htm

Developer services and tutorials: www.drdev.net

Multiple Parameter UD4 / Access 2000 Search Tutorial: www.tdsf.co.uk/tdsfdemo/
Replied 06 Mar 2003 22:12:29
06 Mar 2003 22:12:29 Gil Ben-Horin replied:
Interesting. Well, thanks anyway - you helped me get past a stumbling block that was really holding me up.

Cheers

Reply to this topic