Search / Results with Recordset navigation not working correctly

[danblack30]

I've put together a couple of sites with the same type of Search / Results pages with Recordset Navigation. The search page uses several parameters including first name, last name, and dates (between). While working on the second site I noticed a problem. If you enter a name as a parameter ...(say Dan for example) and there are more than 10 records returned (assume 30 of 100 records have dan as the first name) then the recordset navigation bar appears. Everything up to this point works great, if you try to use the navigation bar to see the next 10 records then you go to 11 to 20 of 100 instead of 11 to 20 of 30 and you get the entire database. Both sites have the same issue. There is no custom code on these pages just the dreamweaver recordset, repeat region, and navigation behaviors. I think the problem might be the recordset navigation is not carrying over the form parameters to the next page. When you first do a search (trying advertising for department) the url ends in searchresults.asp. After using the next button you get "searchresults.asp?Active=%25&LastName=&FirstName=&Res_by=&PhoneExt=&Department=Advertising&Submit=Submit&begindate=&Enddate=&offset=13".(notice the url has advertising for the department, but I get all records anyway). Let me know if I should post the code. Thanks, Dan

 

[danblack30]

I noticed the recordset wrote this to the page

<%
Dim Recordset1__varFirstname
Recordset1__varFirstname = "%"
If (Request.Form("FirstName") <> "") Then
Recordset1__varFirstname = Request.Form("FirstName")
End If
%>

Changing Request.Form("FirstName") to Request("FirstName") the page now filters when the form is posted and later when the url querystring shows up after using the recordset navigation. Still troubleshooting but I would like to keep it all Request.Form. Just Don't like to use a querystring. Any help is appreciated, Dan