I see your problem
Do this example or follow this example if you can comprehend.
Example below::
if (! rs.next())
{
%>
<table><tr><td>empty result set</td></tr></table>
<%
}
else
{
String employee = rs.getString("EMPLOYEE_NAME"));
%>
<table><tr><td><%= employee %></td></tr></table>
<%
}
----- Original Message -----
From: "sunil_s23" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 18, 2001 11:44 AM
Subject: Re: Checking for Empty Result Set
> See the code below, it does not work if there is a
> single row in the result set; in other words the
> statement if(!rs.next()) causes a row of result set to
> be skipped.
> Any suggestions ?,
> Sunil.
>
> ResultSet rs = ps.executeQuery();
> if(!rs.next())
> System.out.println("empty result set");
> while(rs.next())
> {
> System.out.println(rs.getString
> ("EMPLOYEE_NAME"));
> }
>
> --- Satyanarayan Divakar
> <[EMAIL PROTECTED]> wrote:
> > if(!resultSet.next())
> > display"No Records Retreived";
> >
> > -----Original Message-----
> > From: sunil_s23 [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, June 18, 2001 10:27 AM
> > To: [EMAIL PROTECTED]
> > Subject: Re: Checking for Empty Result Set
> >
> >
> > Hi All,
> > A ResultSet is never null once we execute a
> > PreparedStatement and assign the result to the
> > Result
> > Set.
> > Is there any other way of checking whether a
> > ResultSet
> > is empty ?
> > Thanks,
> > Sunil.
> > --- King Maurice <[EMAIL PROTECTED]> wrote:
> > > IF RESULTSET IS EQUAL TO NULL
> > > DO SOMETHING,
> > > SUGGESTION:: NO RECORDS FOUND PLEASE TRY AGAIN
> > >
> > >
> > > ----- Original Message -----
> > > From: "sunil_s23" <[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>
> > > Sent: Monday, June 18, 2001 11:00 AM
> > > Subject: Checking for Empty Result Set
> > >
> > >
> > > > Hello,
> > > > Which is the best method for checking whether a
> > > Result
> > > > Set is empty ?
> > > >
> > > > ResultSet rs = prestmt.exeucteUpdate();
> > > > Checking for rs.isBeforeFirst() returning false
> > > does
> > > > not seem to work always....
> > > > Thanks in advance,
> > > > Sunil.
> > > >
> > > >
> > > >
> > __________________________________________________
> > > > Do You Yahoo!?
> > > > Spot the hottest trends in music, movies, and
> > > more.
> > > > http://buzz.yahoo.com/
> > > >
> > > >
> > >
> >
>
===========================================================================
> > > > To unsubscribe: mailto [EMAIL PROTECTED]
> > with
> > > body: "signoff
> > > JSP-INTEREST".
> > > > For digest: mailto [EMAIL PROTECTED] with
> > > body: "set JSP-INTEREST
> > > DIGEST".
> > > > Some relevant FAQs on JSP/Servlets can be found
> > > at:
> > > >
> > > > http://java.sun.com/products/jsp/faq.html
> > > > http://www.esperanto.org.nz/jsp/jspfaq.html
> > > >
> > >
> > http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> > > >
> > >
> >
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
> > > >
> > >
> > >
> >
>
===========================================================================
> > > To unsubscribe: mailto [EMAIL PROTECTED] with
> > > body: "signoff JSP-INTEREST".
> > > For digest: mailto [EMAIL PROTECTED] with
> > body:
> > > "set JSP-INTEREST DIGEST".
> > > Some relevant FAQs on JSP/Servlets can be found
> > at:
> > >
> > > http://java.sun.com/products/jsp/faq.html
> > > http://www.esperanto.org.nz/jsp/jspfaq.html
> > >
> > http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> > >
> >
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Spot the hottest trends in music, movies, and more.
> > http://buzz.yahoo.com/
> >
> >
>
===========================================================================
> > To unsubscribe: mailto [EMAIL PROTECTED] with
> > body: "signoff
> > JSP-INTEREST".
> > For digest: mailto [EMAIL PROTECTED] with body:
> > "set JSP-INTEREST
> > DIGEST".
> > Some relevant FAQs on JSP/Servlets can be found at:
> >
> > http://java.sun.com/products/jsp/faq.html
> > http://www.esperanto.org.nz/jsp/jspfaq.html
> > http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> >
> >
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
> >
> >
>
===========================================================================
> > To unsubscribe: mailto [EMAIL PROTECTED] with
> > body: "signoff JSP-INTEREST".
> > For digest: mailto [EMAIL PROTECTED] with body:
> > "set JSP-INTEREST DIGEST".
> > Some relevant FAQs on JSP/Servlets can be found at:
> >
> > http://java.sun.com/products/jsp/faq.html
> > http://www.esperanto.org.nz/jsp/jspfaq.html
> > http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> >
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
>
> __________________________________________________
> Do You Yahoo!?
> Spot the hottest trends in music, movies, and more.
> http://buzz.yahoo.com/
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
> For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
