Re: Transactions dilemma

2004-10-19 Thread Egor Egorov
Stuart Felenstein [EMAIL PROTECTED] wrote: I have a slight dilemma. I am using transactions to insert data into multiple tables. All but one table is Innodb. That one is Myisam and it's left as such because its one text column, so I want the benefits of full text search. Still I need

Re: Transactions dilemma

2004-10-19 Thread Stuart Felenstein
Egor, Thank you , I wasn't sure anyone would ever respond to this post :) What I wound up doing is , from the application level, running an if / else. The if checks to see if each $query has succeeded. If any of them failed, I do a rollback. If they all have succeeded, I then do a committ.

Transactions dilemma

2004-10-15 Thread Stuart Felenstein
I have a slight dilemma. I am using transactions to insert data into multiple tables. All but one table is Innodb. That one is Myisam and it's left as such because its one text column, so I want the benefits of full text search. Still I need this transaction to somehow include this entry. Two