SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Wizard aaron.martone's Avatar
    Join Date
    Feb 2003
    Location
    Florida, USA
    Posts
    2,322
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Question Creating a Trigger on Update that makes a web request.

    We are using MSSQL 2008 on a Windows 2008 environment, and I was wondering if someone could help me learn how to make a trigger that would check on update if a particular field met a certain criteria, and if so, send out a predefined request.

    Long story short, we have car GPS data being sent to our DB. One of the values stored during a row update is the car's speed (in a field called 'velocity') In the event it goes over a set threshold (let's say 80), we would like it to make a request to a web page in the format: http://domain.com/file.cfm?carID=[car_id_from_record]&velocity=[velocity_from_record]

    Can someone help point me in the right direction?

  2. #2
    SitePoint Wizard aaron.martone's Avatar
    Join Date
    Feb 2003
    Location
    Florida, USA
    Posts
    2,322
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Any thoughts?

    I've been looking at other solutions like having the application server check the values in the DB on a set interval, but I think that kind of "pull" solution is much less effective than if the DB "pushed" the event when it saw a record get updated/inserted that triggered that event.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •