On Wed Apr 02, 2008 at 11:55:53AM +0200, Mark Lawrence wrote:
> $dbh->begin_work;
> $sth = $dbh->prepare_cached('INSERT INTO artists(id,name) VALUES(?,?)');
> $res = $sth->execute(1,'one');
> ok(!$res, 'insert duplicate id 1');
> $dbh->commit if($res);
> $dbh->rollback if(!$res);
> $sth->finish;Yes, I also know that the transaction stuff is not necessary here, but I was using transactions in my code and just duplicated here. The failure also occurs with autocommit... Mark. -- Mark Lawrence
