You could have the stored proc write a row to a table, and run a CF scheduled task every few minutes to look for that row. When it finds it, have the scheduled task send the web service request.
From: Cameron Johnson <john...@nais.org> To: sql <sql@houseoffusion.com> Date: 05/28/2009 04:05 PM Subject: Re: consume a web service from a stored procedure I wish I could. But the application that is processing the request is (a) a closed, third-party app that is (b) written in .NET. What we do have control over is the validation stored procedure that occurs after a person submits the form. The SP is doing normal database logic first - check for duplicate records in table X, add a new row to table Y, etc.. When all that's done, I need to fire a quick request to the remote web service. Cameron >Huh? > >Stored procedures are for database logic, not web application logic >(which is what this appears to be). > >Do it in CF. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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/sql/message.cfm/messageid:3227 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
