Re: Cross Database Triggers

[Matthew Clements]

ok.

Feel free to tell me to go read a book!

Is there a simple way of stopping a loop occuring between two triggers

i.e trigger on table 1 updates table 2
trigger on table 2 updates table 1

i am getting error 1442 Can't update table %s in stored function/trigger because it is already used by statement which invoked this stored function/trigger.
is there any error handing go ignore this or a simple way of not cascading?

Thanks again