Hi!
Sending SQL strings in PHP like
"set autocommit=0"
"commit"
"rollback"
seemed to work for Andre.
Regards,
Heikki
http://www.innodb.com
-----Original Message-----
From: Andre Konopka <[EMAIL PROTECTED]>
To: Heikki Tuuri <[EMAIL PROTECTED]>
Date: Friday, August 31, 2001 3:32 PM
Subject: Re: Why there are no API-function for transactions?
>Heikki,
>
>it work's as you supposed. I only send at the beginning 'set
>autocommit=0'
>then "COMMIT" and "ROLLBACK" works fine
>
>Again, thank you, have a nice weekend
>
>Andre Konopka
>
>
>
>
>Heikki Tuuri wrote:
>>
>> Andre,
>>
>> can PHP just send the SQL string
>> "COMMIT" or "ROLLBACK" to the server?
>>
>> Some APIs may map these to some function
>> calls, which are not implemented, and thus
>> commit or rollback does not work. You have to
>> test it.
>>
>> In Perl I just do:
>>
>> $dbh->do("rollback");
>>
>> Regards,
>>
>> Heikki
>>
>> -----Original Message-----
>> From: Andre Konopka <[EMAIL PROTECTED]>
>> To: Heikki Tuuri <[EMAIL PROTECTED]>; [EMAIL PROTECTED]
>> <[EMAIL PROTECTED]>
>> Date: Friday, August 31, 2001 3:04 PM
>> Subject: Why there are no API-function for transactions?
>>
>> >Hi,
>> >
>> >maybe I'am wrong but I didn't find any transaction-oriented C-API
>> >functions???
>> >
>> >How can I build a web transaction application with MYSQL/INNOBASE? I
>> >would prefer PHP, but PHP uses the C-library to connect to mysql and
>> >there are no transaction C-API functions...
>> >
>> >
>> >Thanks Andre
---------------------------------------------------------------------
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