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