hi,
why not:
rs = pstmt.executeQuery();
boolean b = false;
if( b = rs.next() ) {
while( b ) {
//... rs.getXXX( YYY );
b = rs.next();
}
}
else {
//...empty rs processing
}
=======================================
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();
> }
>
__________________________________________________
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
