Thanks....this is exactly what I ended up doing. For each search I now
query the database twice...once to get the count and once to get the
actual data. Can this be done in one SQL statement...for performance sake.
-Nash
[EMAIL PROTECTED] writes:
>Normally in SQL you don't know the number of rows until you collect them.
>If you actually need to know before hand, issue the "SELECT COUNT(*) WHERE
>..." call, you'll get a result set with one integer result that is the
>number of rows that a select with the same where clause will return.
> (*Chris*)
___________________________________________________________________________
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
