August 15th, 2003, 10:09 AM
SQL Trigger to Cold Fusion event
We would like to know if it is possible (an how) to make an Cold Fusion event fire after inserting a record into SQL server.
The insert will take place from a off-site database (VFP), we were hoping to use a SQL trigger to do something ???
August 17th, 2003, 02:39 PM
Is ColdFusion doing the insert to the SQL server? If so, you can just wrap the query in a try/catch block and if there is no error CF proceeds with whatever else you want it to do.
If you aren't using CF to insert the record to SQL server, and you just want CF to do something whenever some record gets inserted, this would be more fuzzy. But I'd be stunned if there was not a T/SQL function that lets you initiate an HTTP request as part of a T/SQL procedure. You could call a URL within a CF app that way and have it do something. I know there is a similar function available to do this in Oracle.