On Thu, 2004-07-15 at 01:26, Matthew O. Persico wrote:
> On Wed, 14 Jul 2004 08:18:27 +0200, Michael Peppler typed:
> > On Wed, 2004-07-14 at 02:46, Matthew O. Persico wrote:
> >> the $sth at prepare time and used as such at execution time,
> >> regardless of what the $dbh value is set to?
> > The
On Wed, 14 Jul 2004 08:18:27 +0200, Michael Peppler typed:
> On Wed, 2004-07-14 at 02:46, Matthew O. Persico wrote:
>> I have code that connects to a Sybase database and sets
>> AutoCommit to
>> 0. Subsequent statements all make that assumption and call
>> explicit
>> commits and rollbacks as neede
On Wed, 2004-07-14 at 02:46, Matthew O. Persico wrote:
> I have code that connects to a Sybase database and sets AutoCommit to
> 0. Subsequent statements all make that assumption and call explicit
> commits and rollbacks as needed.
>
> One of those statements was a stored proc that turned out to b
I have code that connects to a Sybase database and sets AutoCommit to 0. Subsequent
statements all make that assumption and call explicit commits and rollbacks as needed.
One of those statements was a stored proc that turned out to be useful when accessed
outside my Perl code. Since the transact
Thanks,
that's the problem, their using MYISAM tables, not Innodb or BDB table handlers
so it won't work! Damn,.. guess that answer that question.. :)
>> Tue, 14 Aug 2001 15:12:48 -0400, [EMAIL PROTECTED] wrote:
>>
>>Which version of MySQL? In the CREATE TABLE statement for members, did yo
;
# other error handling: unlock the table, log a warning, etc.
}
[EMAIL PROTECTED] on 08/14/2001 02:40:35 PM
To: [EMAIL PROTECTED]
cc:(bcc: Wesley Sheldahl/Lex/Lexmark)
Subject: FW: auto commit
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTEC
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 14, 2001 12:49
To: [EMAIL PROTECTED]
Subject: Re: auto commit
On Tue, 14 Aug 2001 12:26:39 -0400, [EMAIL PROTECTED] wrote:
>>You don't mention which database, which might make a
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
27;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 PRO
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 disa
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 erro
11 matches
Mail list logo
