-----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-----