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. No

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

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