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