Getting the number of rows (with Perl DBI)?

Is it possible to get the number of rows returned by a specific search with Perl DBI?

Thanks http://www.datera.com

hi,

you can find out the number of rows returned by a specific search with Perl DBI.

use the following for a select statement:

$rv=$sth->execute;


use the "rows" method to find out return row for non-SELECT statements.

rows:

Returns the number of rows changed (updated, deleted, etc.) by the last command.

This is usually used after a non-SELECT execute statement.

Example:

$rv = $sth->rows;