Bob, Unfortunately since you do not have access from the browser to the native file system you can't do anything past the "Save As" part other then suggest the filename. This is for security reasons since if the browser could do that it could also do things like overwrite files and delete Hard drives... The only way you could so something like this is using AIR which runs on the desktop and does have file system access.
J.J. On 3/20/08 8:57 AM, "Bob Imperial" <[EMAIL PROTECTED]> wrote: > Hi Folks, > > I am trying to figure out how to go about taking data pulled from a MSSQL DB > and writing it to an xls file, naming it and saving it to a specific directory > with minimal user action. I know how to go about basic exporting to xls using > <cfheader name="Content-Disposition" > value="filename=IPAddresses_#ThisFile#.xls" /> > <cfcontent type="application/vnd.ms-excel" /> but this requires more user > interaction to save it to a specified directory. I'd like to be able to do it > all in code in the simplest manner possible ... if possible :) I'm running > CFMX7 Standard and Windows Server 2003, MSSQL 2000. The simpler the better for > a slow mind here :) > > TIA Bob > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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-Newbie/message.cfm/messageid:3466 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
