If the number of rows affected is known,
then for non-select actions, the execute
method will return the number of affected rows. But the
driver (and hence the DBI), can only do that if the database
is returning this information. You can also call the
method rows on the statement handle to get
the result from the last execute.
You will have to write the code to sum the results from the
various executes yourself, but that shouldn't
be too hard.
Abigail | [reply]
[d/l]
[select] |
if $sth is your executed sql statement, you can get the number of records affected via $sth->rows. (using Oracle at least)
---- amphiplex | [reply] |
According to DBD::mysql you can use $sth->rows, not that I've ever tried... I dont know about DBD::Oracle however.
T
I
M
T
O
W
T
D
I | [reply] |