Trigger does not work from Cold Fusion application

[Hao Tang]

Hello there,

We have tested the trigger working fine for "INSERT" event by testing it through "INSERT" statement. It didn't work when "INSERT" statement in the Cold Fusion application. We have master and several slaves servers. If we have the trigger on master server, everything works (even calling from Cold Fusion application). When the trigger only creates on slave servers, trigger stops working. We prefer to create a trigger on slave servers and it causes overheads when the trigger on the master.

Does anybody have any experience with Cold Fusion applications? Why does the trigger work only on the master server not on the slave?

Thanks so much for your help!

-Hao