Send the set autocommit=0 just as you send any other query in perl.
Bob Boden wrote:
>Attempts to disable auto-commit mode in Perl using the DBI command
>$dbh->{AutoCommit} = 0; returns the following message, "Transactions not
>supported by database".
>
>I am using the latest version of MySQL-Max (3.23.51) as well as the latest
>version of DBD::mysql.
>
>Executing the following command at the mysql prompt verifies that BDB
>Transaction enabled tables are supported and turned on.
>mysql> SHOW VARIABLES LIKE "have_%";
>+---------------+----------+
>| Variable_name | Value |
>+---------------+----------+
>| have_bdb | YES |
>| have_gemini | NO |
>| have_innodb | DISABLED |
>| have_isam | YES |
>| have_raid | NO |
>| have_openssl | NO |
>+---------------+----------+
>6 rows in set (0.00 sec)
>
>Executing SET AUTOCOMMIT=0; at the mysql prompt works fine as well. However,
>I can not get Perl scripts to recognize the disable auto-commit command.
>
>These symptoms are occurring in a Linux/apache web server as well as a
>Windows 2000 environment running as "localhost".
>
>Any suggestions would be greatly appreciated.
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
