-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
On Wed, 26 May 2004, Randy J. Ray wrote:
From the DBI manpage:
"rows" $rv = $sth->rows;
Returns the number of rows affected by the last row affecting com- mand, or -1 if the number of rows is not known or not available.
I guess it may have just been good luck that ->rows did what I needed it to do with DBD::MySQL. My tables and queries are very simple.
At any rate, I took Puneet's advice and did a $dbh->selectall_arrayref, used the scalar value of the arrayref to get the count of rows returned, then iterated over the arrayref to do my row-level processing.
Thanks, Wade -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (FreeBSD)
iD8DBQFAtORzo4DwsyRGDscRAggoAKDLxwcwxlxI91N5muE7V473vNAbcACgx4A4 lGXJchb0Byun0ybf9fwDhaU= =5aOW -----END PGP SIGNATURE-----
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]