running one resultset value in another another resultset

[ktsrikanth]

hi
I have two resultsets connected to the same database but to the two different tables. when i try to run a resultset value stored in a variable and use it in another sql statement which is run by another resultset, i get internal server error.
I am using servlets in apache webserver with jserv configured to the apache.

Please send me the solution to thei fast
Thank you

 

[LeonTang]

Hi,

I encountered this problem before but I doubt the problem lies in running the value of a resultset in another resultset.

I solved the problem already but couldn't seem to remeber what is causing the error.

So perhaps you would like to copy and paste the codes in the forum or send me the codes to have a better look at it?

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