Does the ResultSet have to be scrollable for this to work? I'm getting an error that tells me that my result set isn't scrollable. I think it's weird because I can make a call on rs.next() in a while loop using a default resultset without a problem. Confusing...
- Keith -----Original Message----- From: David Graham [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 1:35 PM To: Struts Users Mailing List Subject: Re: [OT] Empty Result Set boolean isEmpty = !rs.next(); David --- "Kamholz, Keith (corp-staff) USX" <[EMAIL PROTECTED]> wrote: > Hey everyone, > This isn't really a struts question, but it's applicable. I'm just > wondering how to find out if a ResultSet is empty or not after I execute > my > query. I've searched online, but I'm having a hard time finding much of > anything. > Can I just use: > > if (myResultSet.next() ) > { > empty = false; > } > else > { > empty = true; > } > > > Would that work or would that not do what I'm looking for? > Any help would be appreciated, thanks! > > - Keith > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]