Re: (ot) How to call a .cfm page from a MS SQL Server trigger or stored procedure
I have a vbs script that takes a URL as an input that I can call from SQL Server to execute Web code. However, I wouldnt call this script inside of a trigger and would be concerned about holding open the database transaction. You would probably want a solution that would allow the transaction to close quickly and allow the desired process to run in the background. If you want something that will rollback the transaction if the Web code fails, then maybe you do want to hold open the transaction. Otherwise, the technique that comes to mind is to write an entry to a database table and have a scheduled task query that database table looking for records to process. You could also look into using the SQL Service Broker. -Mike Chabot On Fri, Aug 14, 2009 at 5:13 PM, Michael Reick wrote: > > 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:325475 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: (ot) How to call a .cfm page from a MS SQL Server trigger or stored procedure
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
RE: (ot) How to call a .cfm page from a MS SQL Server trigger or stored procedure
Look into calling a web service from a CLR. It'll be a hack job and will require some C#, but the database doesn't generally initiate communication with the application layer. Ideally, if additional processing needs to occur any time certain data is changed, that sort of stuff should probably be routed through your application's service layer. ~Brad Original Message ---- Subject: (ot) How to call a .cfm page from a MS SQL Server trigger or stored procedure From: Michael Reick 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? ~| 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:325462 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
(ot) How to call a .cfm page from a MS SQL Server trigger or stored procedure
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:325460 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4