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

    Join Date
    Aug 2003
    Location
    Philadephia
    Posts
    16
    Rep Power
    0

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

    Thanks
  2. #2
  3. No Profile Picture
    Moderator

    Join Date
    Jun 2002
    Location
    Raleigh, NC
    Posts
    5,277
    Rep Power
    968
    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