Something like a trigger would be perfect. But the thing is I need to do some stuff that is not DB related (like send a message, etc). Can the trigger call a cfc or do an http call to some cfm? Can a stored proc call that? I've usually had my cfm calling stored procs not vice versa. Interesting thought.
>How about a database trigger which calls a stored procedure to do that >processing? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288045 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

