Steve, the trick is to create a new column TRIGGER_INACTIVE and only set
a value when you are updating the data from the trigger, as in:

UPDATE <tablename>
SET <blah>=<blech>
SET TRIGGER_INACTIVE = 1
WHERE....

Then modify your trigger(s) as required to check for the value of the
TRIGGER_INACTIVE column.


Sean