Would you be able to send me the command your dba uses to open a http page through sql?
----- Original Message ---- From: Andy Matthews <[EMAIL PROTECTED]> To: CF-Talk <[email protected]> Sent: Friday, January 25, 2008 3:04:17 PM Subject: RE: SPAM: Re: is it possible to open cfml page from sql server stored procedure? You can certainly run CFM pages via their http path. Our dba does that all the time when he needs to trigger something on the CF side. -----Original Message----- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Friday, January 25, 2008 3:34 PM To: CF-Talk Subject: SPAM: Re: is it possible to open cfml page from sql server stored procedure? 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:297500 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
