Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
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
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!