HELP!!! with ResultSet

[scohan]

Within a jsp page, I have a form that submits to the same page. In this page I also make a db query that returns a resultset. The first time through the query works fine, however, after submitting the form and coming back through the page a second time, the resultset is null after excuting the query. I qualify the query using the same parameters I used the first time through so I should get data back. The resultset is set to null at the top of the page before the query is executed.

I'm really stuck. I've lost a whole day on this and I'm working on losing a second day. Any advice would be GREATLY appreciated. Thanks.

 

[LeonTang]

Hi,

I have seen your previous post on this same error before so I suggest that if possible, post the entire jsp code onto the forum? Those that you have posted before are insufficient to locate the error.

Regards,
Leon If you need additional help, you can email to me at zaoliang@hotmail.com I don't guaranty that I will be able to solve your problems but I will try my best

 

[scohan]

Thanks, but I think I found the culprit. I explicitly passed a paramater to the page and then I use request.getParameter to evaluate it. But this was somehow causing the problem. I solved it by creating a seesion variable. This parameter is also part of the sql qualifier so I guess that's why the rs was crapping out. Thanks for the response though.