oops! you're right.. hadn't noticed this li'l thingy in your construct...
...
hasResults = rs.next();
this part'll ensure that the we're still at the first, my mistake! your method'll
work too.
sorry bout that!
regards
vijay
Matthias Brantner wrote:
> HI
>
> > u could also have a counter for numbers initialize it to zero before the loop
> > and if it's still zero after the loop, the u know ur query returned null. the
> > disadvatange of using
> > the following(with due apologies to Matthias):
> > ResultSet rs = executeQuery(Select);
> > boolean hasResults = rs.next();
> > if (!hasResults) {
> > ...
> > }
> > else {
> > while (hasResults) {
> > ...
> > hasResults = rs.next();
> > }
> > }
> > is that u will have skipped one item in the query due to ur having asked it to
> > go to the next item(rs.next()) during ur check. The only way around this is
> > creating another resultset, which, needless to say is a waste of time given
> > that there r easier solutions.
> you don't have to apologize, because you won't skip one item. The cursor
> in the ResultSet is before the First Element at the beginning. So, you
> move to the first, then you get the first result, you move to the
> next...
>
> See you
> Matthias
>
> ___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
