Forum Moderators: open

Message Too Old, No Replies

Recordset Paging- Error

         

dupati1

1:37 pm on Oct 21, 2003 (gmt 0)

10+ Year Member



Hi All,

I am facing the same problem(solved) already referred in this forum and can be found at [webmasterworld.com...]

I am using a form on which there are various fields and users can select any combination of the fields to search the desired records.

Since the database i am using is very large, i wanted to show these results in a paged fashion. But i am able to show only the first page and not the remaining pages.

As this problem has already been discussed in the forum(refer above link), Mr.socoolbrewster came up with a solution saying..,

"Basically the problem with the script was mainly due to nature of the scripts function. As on passing the variable value from the form to the script on loading the next page(s) the value for the strSearchtxt variable became NULL hence causing the script not to proceed and display an EOF or BOF error. Therefore the script need to call that value from the form again. "

But in his case there was only one search field which he could refer again using

<a href="fiveon.asp?Page=<%=PageCounter%>&cool=<%=request("cool")%>"><%=PageCounter%></a>

but in my case there are various search fields...

How can i refer them again or fetch them from the form.

Any suggestions. Thanks in advance.

VJ

wardbekker

1:53 pm on Oct 22, 2003 (gmt 0)

10+ Year Member



add more parameters to the querystring like:

<a href="fiveon.asp?Page=<%=PageCounter%>&par1=<%=request("par1")>&par=<%=request("par2")%>%>"><%=PageCounter%></a>