Ti would be better to use the count(*) call. If your query say returned 2
000 000 rows, you'll be waiting a while to scan to the end of that. I'm not
sure you're user would find all of those useful either.
Thor HW
----- Original Message -----
From: "Srini Sathya." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 09, 2000 9:05 AM
Subject: Re: Number of Records
> can any1 let us know hwo to find that in JDBC1.0??
>
> Cheers
> Srini
>
> -----Original Message-----
> From: Sven van 't Veer [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 09, 2000 4:31 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Number of Records
>
>
> Andrew Wallace wrote:
>
> > But for those of you using JDBC 2.0 how about:
> >
> > if (rs.next()) {
> > rs.afterLast();
> > rs.previous();
> > noOfRecords = rs.getRow();
> > }
> and in that case why not:
> if (rs.next()) {
> rs.Last();
> noOfRecords = rs.getRow();
> }
>
>
> sven
>
> --
>
============================================================================
> ==========
> Sven van 't Veer
> http://www.cachoeiro.net
> Java Developer
> [EMAIL PROTECTED]
> _/_
> The answer / \
> to the ultimate question nnn|.
> .|nnn 42
>
=========================================U==================================
> ==========
>
>
___________________________________________________________________________
> 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
>
___________________________________________________________________________
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
