I don't get the problem. Create a Service Object (CFC) with a function that handles this process.
Submit to your action page, send the form struct into the function. Inside the function, call the stored procedure & pass in the form data. Have the SP return the new ID and a bit value indicating that this is a new record. If you call the web service when a new record is created, then do that, otherwise, skip it and return a boolean value or the ID from the new record from the function to whatever process called the function. -- Adrian ---------------------------------------- From: "Cameron Johnson" <john...@nais.org> Sent: Thursday, May 28, 2009 4:05 PM To: "sql" <sql@houseoffusion.com> 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:3226 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
