> Submit to your action page, send the form struct into the function. I don't have access to the form or the action page. Those are part of the proprietary, third-party software that runs our e-commerce. What I can do is add pre- and post-process SPs to validate data, fire off other SPs, etc.
Being a CF developer first, I'd prefer to create a CFC or a simple CFM page to do the web service call. But the higher problem still exists: what do I put into the SP to initiate the call? Or, put differently, how do I communicate to a web app from an SP? More searching turned up this example: http://blog.davebouwman.com/index.php/2008/07/call-geonames-web-services-from-a-sql-stored-procedure/ I was hoping someone on this list had done something similar. Cameron ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:3229 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
