>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 > >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:3228 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
