> My goal is to run a series of stored procedures. At one point, while > I run the stored procedures, I need to run coldfusion code which has > a cfquery tag and some complex if and else conditions which are > easier done in coldfusion than t-sql.
I would think that if it is conditionals (regardless of the complexity) that it would make more architectural sense to do everything within SQL. Granted, you may want to build a user defined function to handle the comparisons, but that would be more effective and portable than utilizing WGet or cURL. If you go the route of the executables, you will need to obtain them and install on your server. Neither are included with Windows. Your other option would be to move everything into CFML. Hatton ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297521 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
