-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thu, May 10, 2001 at 09:58:17PM -0700, Vargas, Steven wrote:
> $h->rows count is incomplete before all rows fetched.

You apparently didn't read the Fine Manual's note about using $sth->rows with
SELECT statements.

           Generally, you can only rely on a row count after a
           non-"SELECT" "execute" (for some specific operations
           like "UPDATE" and "DELETE"), or after fetching all the
           rows of a "SELECT" statement.

           For "SELECT" statements, it is generally not possible
           to know how many rows will be returned except by
           fetching them all.  Some drivers will return the
           number of rows the application has fetched so far, but
           others may return -1 until all rows have been fetched.
           So use of the "rows" method or "$DBI::rows" with
           "SELECT" statements is not recommended.

           One alternative method to get a row count for a
           "SELECT" is to execute a "SELECT COUNT(*) FROM ..."
           SQL statement with the same "..." as your query and
           then fetch the row count from that.

- -- 
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>

-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8

iQA/AwUBOvtypQOGqGs0PadnEQLy8QCgwX+LFGXi6/cAr9xKECOKEmMqol4AniRq
eRfOUP4vvlJP1njohs9nWlSW
=37Oi
-----END PGP SIGNATURE-----

Reply via email to