For selecting data you have to use
rs2 = statement.executeQuery(select * from table where column1
="+rs1.getString("id"));
and not executeUpdate which is used for DML(Data Modling Language update,
delete and insert) orders.
-----Message d'origine-----
De : Eric Stiles [mailto:[EMAIL PROTECTED]
Envoy� : mercredi 19 mars 2003 16:52
� : [EMAIL PROTECTED]
Objet : dbtags: Inner resultset looping
I just started using the dbtags and am curious if it is possible to do
something along the lines of the following:
while (rs1.next()){
rs2 = statement.executeUpdate(select * from table where column1 =
rs1.getString("id")
while (rs2.next()){
//do something with rs2 tuple
}
}
I am not too familiar with JSTL so if that is the solution, a little more
explanation would be very helpful.
Thank you
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
