aspose file tools*
The moose likes JDBC 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 EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "resultset" Watch "resultset" New topic
Author

resultset

anu manju
Greenhorn

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
Hi
That depends on the visibility of the first resultset. But u can iterate 2 result sets together
Cindy Glass
"The Hood"
Sheriff

Joined: Sep 29, 2000
Posts: 8521
sureshg,
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.
Thanks,
Cindy
[ May 06, 2003: Message edited by: Cindy Glass ]

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

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: http://aspose.com/file-tools
 
subject: resultset
 
Similar Threads
servlets
Passing ResultSet
resultset
Can we extract the data from resultset after the connection get closed.
Jdbc Prepared Statement execute()