Re: [PHP-DB] Automattic Rollback on User Cancel with MySQL

2002-10-19 Thread Rasmus Lerdorf
PHP 4.3 handles this correctly. Give a snapshot from snaps.php.net a try. -Rasmus On Fri, 18 Oct 2002, Benjamin Schleinzer wrote: Hi I Am using the latest PHP version 4.2.3 with MySQL 3.23.51-max. I use InnoDB tables for transactions and everything works fine with Rollback and Commit. But

Re: [PHP-DB] Automattic Rollback on User Cancel with MySQL

2002-10-19 Thread Yasuo Ohgaki
IIRC, someone added automatic rollback to MySQL from PHP 4.3.0 just like PostgreSQL. BTW, PostgreSQL module rollbacks uncommitted transaction automatically from PHP3. -- Yasuo Ohgaki John W. Holmes wrote: I Am using the latest PHP version 4.2.3 with MySQL 3.23.51-max. I use InnoDB tables for

RE: [PHP-DB] Automattic Rollback on User Cancel with MySQL

2002-10-18 Thread John W. Holmes
I Am using the latest PHP version 4.2.3 with MySQL 3.23.51-max. I use InnoDB tables for transactions and everything works fine with Rollback and Commit. But when the user presses cancel in the browser or the script stops due to an error in the script all open transactions are committed