Here is a very trimmed down sample snip:


$dbh->do('LOCK TABLE members WRITE');
$dbh->do('begin');

$query = qq|UPDATE members SET payment = ? WHERE username = ?|;
$sth = $dbh->prepare($query);
$sth->execute($pay,$user);
$sth->finish() if $sth;

$dbh->do('commit');
$dbh->do('UNLOCK TABLE');
$dbh->disconnect() if $dbh;


>>On Tue, 14 Aug 2001 11:18:33 -0400, [EMAIL PROTECTED]   wrote:

>>Can you provide some code?
>>
>>-----Original Message-----
>>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>>Sent: Tuesday, August 14, 2001 10:02
>>To: [EMAIL PROTECTED]
>>Subject: auto commit
>>
>>
>>Hello All,
>>
>>When setting AutoCommit => 0, with transactions, does anything else need to
>>be
>>set to disable Autocommit? It seems that the Autocommit => 0 is being
>>ignored in
>>our script. If it's set to '0' is still seems to process the queries with or
>>without invoking the $dbh->{'commit'} and no error is generated?
>>
>>I'm I missing something. ??
>>
>>THX's
>>
>>Mike(mickalo)Blezien
>>=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
>>Thunder Rain Internet Publishing
>>Providing Internet Solutions that work!
>>http://www.thunder-rain.com
>>Tel: 1(225)686-2002
>>=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Reply via email to