This definitely caters to the case when there is only
one row in the result set; but what about the case if
the result set contains more than one row. I am
looking for a solution which will handle both single
row results and multiple row results as well as the
case when the result set is empty.
Any suggestions ?,
Thanks,
Sunil.
--- King Maurice <[EMAIL PROTECTED]> wrote:
> 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:
>
=== message truncated ===
__________________________________________________
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
