Yes, that won't work correctly. A Statement can only be used to read one ResultSet at a time. As soon as you execute the second query, the first ResultSet is automatically closed. If you need to read from more than one ResultSet at a time, then you must use different Statements.
Blake Minghelli<br />SCWCD<br /> <br />"I'd put a quote here but I'm a non-conformist"
posted 14 years ago
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads