1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Rep Power

    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 ???

    Any ideas......???

  2. #2
  3. No Profile Picture

    Join Date
    Jun 2002
    Raleigh, NC
    Rep Power
    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.

IMN logo majestic logo threadwatch logo seochat tools logo