If the database is located on the same box as CF, you could consider the following:
Set trigger in table to fire when field/row is changed. trigger calls a stored procedure which does some processing and then writes to a file. Set CF File gateway to watch that directory that the stored procedure is writing the file to. CF can then pick up from there and send a message or whatever. The file name can be the id of the customer or the file can contain whatever information you need to pick it back up. Does that make sense? There's probably many other ways to solve this but this might be an option. Vince Anthony Webb wrote: > 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. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:288047 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
