in reply to (jeffa) Re: DBI multiple prepares
in thread DBI multiple prepares

It is possible to use placeholders with do. The syntax is:
$rows = $dbh->do("UPDATE your_table SET foo = ?", undef, $foo);
However, you don't need to use do though. execute returns the number of rows updated for a non-SELECT statement.