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