whzt i want?
i would like to show 10 records at a time on a
jsp page and ther will be a button that will reload the same page to show the next 10 records in the same resultset.how can i achieve this?
what is happening?
when i show the first 10 records i put the resultset in session and the statement object in the <%!%> tag.if i put this tag outside the body of the jsp then i get the error that statement object is unknown when i try to access it.so i keep it in the body tag of the jsp page.secondly when i do that then it shows me the next 10 records but then on subsequent clicks on the button it says resultset is closed.please guide me.thanks you very much well in advance.