>>> 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'
You can do this several ways You can use "EXEC master..xp_cmdshell" which I am assuming is a call the CMD or windows command shell and use that to call an app that can make a http call like Wget http://www.google.com/search?q=Wget&sourceid=navclient-ff&ie=UTF-8&rlz=1B3GGGL_enUS233US233 or CUrl. http://curl.haxx.se/ Or you can call the actual CF executable using a bat file and have it run the script. The last time I saw that done was some 5 years ago on cf 5 so I am sketchy on the details I am sure there are other ways but those are the two that come to mind. Gerald > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:297501 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
