> > 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.
I would second C's (Hatton's?) recommendation. Calling CF code from SQL may be easier to do now (assuming you've already written the CFML) but it will be harder to maintain that sort of violation of application partitioning in the future. It also requires your database server to be able to make HTTP requests, which is often prevented or at least limited in secure environments for obvious security reasons. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:297532 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
