Re: problems with transactions

On Thu, Aug 31, 2000 at 09:43:52AM -0300, Campbell, Scott wrote:
>
> $sth = $dbh->prepare("begin work");
> $sth->execute();
>

[snip error]

>
> after seeing this I assumed that you just can't use the begin statement
> accross the DBI but there has to be a way of opening a transaction (it even
> says so in the error I got) ... I'm just not sure how.
>
> can someone please shed some light on this... I've looked through the
> archives but didn't find anything constructive.

man DBI

Look for the section on AutoCommit, and the section on Transactions
will also be useful. One sentence summary: Make sure autocommit is
off, transactions are begun automatically, and ended with commit or
rollback.

Jules