http://www.jguru.com/jguru/faq/view.jsp?EID=115622
Joe Sam
Joe Sam Shirah
Autumn Software - Consulting/Development/Outsourcing
Just the JDBC FAQs: http://www.jguru.com/faq/JDBC
Going International? http://www.jguru.com/faq/I18N
----- Original Message -----
From: "James Lee" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 24, 2000 12:27 PM
Subject: how to check ResultSet is null or not?
> Hi All,
>
> I want to display a message when the ResultSet is empty from the database.
> But when I try to check ResultSet by using the following methods like:
> if ( rset == null ) {
> // display the message
> } else {
> // display the results
> }
> it seems not working. I also tried to use
> if ( !rset.next() ) and if (!rset.first()) but none of them seems
> work.
>
> I am using Weblogic JDBC2.0 connection pool. It works fine if I do not
> check the ResultSet and just display them. Only thing is I got a blank
page
> if no results.
>
> Any suggestions?
>
> James Lee
>
>
___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
