Discover Antartica wrote: > Hello All > Is there a way to execute a coldfusion file from a microsoft sql server > stored procedure? > In other words, since cf files don't have a .exe extension, is it possible to > open a cfml page from a sql stored procedure? > > note: > i can open sql files and run them by using commands such as the following: > > EXEC master..xp_cmdshell 'osql -E -i > \\mycomputernetworkname\Driveletter\foldername\testing.sql' > > best regards > DA
UMMM maybe. You could possible open the browser executable (ie.exe for example) with the url to the CFM template is a parameter. What good this would do for you I can not imagine. In other words you are not likely able to do what you are trying to do. CFML is not meant to be run outside of a web-server/client environment. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:297481 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
