It's Oracle, is indicated by the ORA in the error number. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/
2009/8/14 Mike Chabot <mcha...@gmail.com>: > > You might want to specify which database you are working with. You > would not get that error in MS SQL Server. > > -Mike Chabot > > On Thu, Aug 13, 2009 at 10:49 AM, Nick G<moxiew...@gmail.com> wrote: >> >> I have a table with four values (val1, val2, val3, overall_val). I have been >> trying to create a trigger where after an update is made to either one of >> the first 3 values, the sum is added and updated into the overall_val field >> [ for each row ]. I can not separate the fields into a different table and I >> know this is not the best way to show/store a total field but it is what I >> have to work with. Currently when I try a basic update after trigger I get >> the ORA-04091 is a mutating trigger error because the :new.val has not been >> committed. Does anyone know of a work around to update a row in the same >> table that fired the trigger? Thanks in advance. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3235 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
