Wow, a little protective of your code, eh?
First, his question was he didn't want to retrieve all records in order to
determine how many records are being returned. Why don't you tell me how
fetchRecords() works?
Next, given your obvious lack of experience in reporting tools, the odds greatly
increase that a large set of records is going to be pulled down (perhaps to a
tab-delimited file, perhaps to be turned into a pdf report) when you start actually
developing applications in servlets that are used at a corporation. There aren't
too many 20 line sales reports, jon star. More often than not, they can be fifty or
a hundred pages, with analysis, or possibly ten thousand records used to create a
chart, or maybe more. You just never know.
So, stupid as it may be to someone with little experience outside of a little mySQL
database running queries on the number of support requests for Village or Town, I
can assure you that you oversimplify.
jon * wrote:
> > Presumably, "qds.fetchRecords()" returns what -- a Vector of Hashtables (or
> > Village objects) or something?
>
> Go look at the source code. It is there for a reason.
>
> >That's the same thing as calling ResultSet.next()
> > until the ResultSet is exhausted, so that doesn't solve his problem.
>
> Wow, you like to argue. His problem was that he didn't know how many rows
> were being returned. My solution does solve his problem because it tells you
> how many rows were being returned.
>
> > Plus, what
> > if this is going to be a monumental number of records that is apt to blow out
> > memory? Do you have a way to iterate through the ResultSet?
>
> If one is returning a monumental number of records that can blow out the
> amount of available memory, then, bluntly, one is an idiot.
>
> Please take a look at my source code for exactly how fetchRecords() works.
>
> -jon
>
> ___________________________________________________________________________
> 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
