Java Help - result set in jsp

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

result set in jsp

ashutosh

2005-06-03, 3:58 am

i want to use two result sets in my coding like:

rs = st.executeQuery("select qty from instance where instance_name
='kvm' ");
rs.first();
rs1= st.executeQuery("select status from reservation where
instance_name='kvm' ");
rs1.first();

i m not able to use it like this, its generating errors. please tell
how can i do this.

Manish

2005-06-03, 9:08 am

use two statement object...st1 and st2
st1.executeQuery("firstQuery");
st1.executeQuery("secondQuery");

Manish

2005-06-03, 9:08 am

use two statement object...st1 and st2
st1.executeQuery("firstQuery");
st2.executeQuery("secondQuery");

Manish

2005-06-03, 9:08 am

use two statement object...st1 and st2
st1.executeQuery("firstQuery");
st2.executeQuery("secondQuery");

Sponsored Links