• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

help on transactions

 
Piradharsan Navaratnam
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello friedns I need to run a query and based on its results to run another query. How can I implement it. Im using mysql innodb.



[ UD: added CODE tags for better readability ]
[ August 19, 2007: Message edited by: Ulf Dittmer ]
 
Ulf Dittmer
Rancher
Posts: 42969
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You don't say what happens if you run the code, but I'm guessing that it doesn't work because there can only be a single ResultSet active per Statement. Try what happens if you use different Statement objects for rs_02 and rs_03.

In the future, please UseCodeTags when posting ocde of any length.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic