Sound like what needs to be done can't be done or very inconvenient to be done at db end hence you need to run some cfm page from db end.
Not sure if it's efficient, doable though. call "sp_shellcmd", (look it up for sp for shell command), have some utility like wget, then, "wget http://yourURL"; something. > I've done a ton of Googling, (is that a word??) and so far I can't > find > the answer, so I figured I'd ask here. > > I've got a trigger that runs when certain tables are updated, which > updates some other tables, but I'd like it to call a .cfm page (either > > on the database box or a different box) that does some other tasks. > Is this possible? > > Specifics: > DB Server: MS SQL Server 2005 > OS: Windows 2003 > > Thanks! > > Michael Reick > > > __________ Information from ESET NOD32 Antivirus, version of virus > signature database 4336 (20090814) __________ > > The message was checked by ESET NOD32 Antivirus. > > http://www.eset.com > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325474 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
