I tried the following: EXEC master..xp_cmdshell 'wget http://www.example.com/index.cfm'
I got this error message: 'wget' is not recognized as an internal or external command, operable program or batch file. ----- Original Message ---- From: Russ <[EMAIL PROTECTED]> To: CF-Talk <cf-talk@houseoffusion.com> Sent: Friday, January 25, 2008 3:24:50 PM Subject: RE: is it possible to open cfml page from sql server stored procedure? EXEC master..xp_cmdshell 'wget http://www.example.com/index.cfm' > -----Original Message----- > From: Cutter (CFRelated) [mailto:[EMAIL PROTECTED] > Sent: Friday, January 25, 2008 4:44 PM > To: CF-Talk > Subject: Re: is it possible to open cfml page from sql server stored > procedure? > > Yes, you can use a DTS package to run a script that makes an HTTP call. > > Steve "Cutter" Blades > Adobe Certified Professional > Advanced Macromedia ColdFusion MX 7 Developer > _____________________________ > http://blog.cutterscrossing.com > > 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 > > > > > > > __________________________________________________________________________ > __________ > > Never miss a thing. Make Yahoo your home page. > > http://www.yahoo.com/r/hs > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:297498 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4