this works for sure. But how do I know the case when
the result set is empty ?
Thanks,
Sunil.
--- Ron Chan <[EMAIL PROTECTED]> wrote:
> hi,
>
> only just saw this thread so maybe not understanding
> the entire problem but it sound like you want to do:
>
> rs = pstmt.executeQuery();
> boolean b = rs.next();
> while( b ) {
> ... rs.getXXX( YYY );
> b = rs.next();
> }
>
> --- sunil_s23 <[EMAIL PROTECTED]> wrote:
> > 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.
>
>
> __________________________________________________
> 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
__________________________________________________
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
