How about a database trigger which calls a stored procedure to do that processing?
Anthony Webb wrote: > CF ships with the directory watcher gateway which is pretty cool. Saves from > having to set those scheduled tasks for every 5 min watching for changes in a > directory. > > I have had need lately to do that same thing on a DB table. A sort of queue > system where I will write records to a DB table, then CF can work on those > items deleting them as they are complete. Of course I could schedule a task > to check the DB table periodically. But I am wondering if you know of or had > any experience with some sort of a "table watcher" event gateway. > > Is there a better way to do what I want to implement a queue of tasks? The > example case would be someone sending via my API a large list of > notifications to be send (each requiring a subsequent http call). Rather > than making the user wait for each call to me made, he simply hands off the > list to my "queue" and then gets a response that we are working on the list. > > Thanks Guys. > > _________________________________________________________________ > Gear up for Halo® 3 with free downloads and an exclusive offer. Its our way > of saying thanks for using Windows Live. > http://gethalo3gear.com?ocid=SeptemberWLHalo3_WLHMTxt_2 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:288039 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
