You don't mention which database, which might make a difference.
The finish() after the UPDATE won't do what you think it will. It should
only be used after a SELECT query. The cheetah book talks about it on p.
117.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 14, 2001 11:47
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: auto commit
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
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=