Economical way, your right its kinda tedious, but it only about 4 simple
lines of code, how economical can you get, just pure laziness maybe, but
that is up to your discretion, as long as you get the job done.
----- Original Message -----
From: "sunil_s23" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 18, 2001 12:07 PM
Subject: Re: Checking for Empty Result Set
> That calls for two sql statements; is there a more
> economical way out ?.
> The following code seems to work, but not always.
> Any pointers ?
>
> ResultSet rs = ps.executeQuery();
> if(rs.isBeforeFirst() == false)
> {
> System.out.println("empty result set");
> }
> else
> {
> while(rs.next())
> {
>
> System.out.println(rs.getString("EMPLOYEE_NAME"));
> }
> }
>
> --- King Maurice <[EMAIL PROTECTED]> wrote:
> > Well the get the count of the resultset in your sql
> > command and then test
> > for a condition of one
> >
> > You need to figure out on your own, the conditions
> > in your code, if not your
> > lost!!!!
> >
> > Maurice~
> >
> > ----- Original Message -----
> > From: "sunil_s23" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Monday, June 18, 2001 11:58 AM
> > Subject: Re: Checking for Empty Result Set
> >
> >
> > > 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
> >
> === 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
>
===========================================================================
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
