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