• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

ResultSet Thru ResultSet

 
Sanjay Deshpande
Ranch Hand
Posts: 111
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a result set rs.
Depending on some value from rs i wanna get another resultset rs2with diff query.
How to do this?
I ve code like this

IS IT OK?
[ Edited by Dave to format code ]
[ May 19, 2002: Message edited by: David O'Meara ]
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
you might want to change

to this

Also, if you expect many rs1's, then it might be worth your while to use a prepared statement in the while loop.
Jamie
 
Mahesh Mamani
Ranch Hand
Posts: 110
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
U may also consider putting creating and closing the Statement calls for the second rs outside the loop. U may check time-difference among the two processes and decide.

MSM
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic