File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes resultset Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "resultset" Watch "resultset" New topic


anu manju

Joined: May 03, 2003
Posts: 8
ow to use resultset within another while loop of another resultset
suresh guru
Ranch Hand

Joined: Sep 07, 2002
Posts: 38
That depends on the visibility of the first resultset. But u can iterate 2 result sets together
Cindy Glass
"The Hood"

Joined: Sep 29, 2000
Posts: 8521
Thanks for working with this person, however please change your name to be compliant with JavaRanch's naming policy. It should not be obviously fictitious.
Your displayed name should be 2 separate names with more than 1 letter each, we really would prefer that you use your REAL name.
You can change your name: here.
[ May 06, 2003: Message edited by: Cindy Glass ]

"JavaRanch, where the deer and the Certified play" - David O'Meara
amit mohanty

Joined: May 07, 2003
Posts: 5
Create separate statement for each resultset. Then only you can use one resultset inside while loop of another resultset.
Mike Curwen
Ranch Hand

Joined: Feb 20, 2001
Posts: 3695

moved from servlets -> JDBC
I agree. Here's the link:
subject: resultset
It's not a secret anymore!