I'm having this dreaded issue with SSL and IE and exporting
query data to an Excel spreadsheet. At first I was getting this:
internet explorer cannot download [filename] from [server].
Internet Explorer was not able to open this Internet site.
The requested site is either unavailable or cannot be found. Please
try again later.
I searched here and on the livedocs and found the caching
issue when trying to do this on an SSL server. I found the
offending cfheaders in an OnRequestEnd.cfm file and commented them
out. Now the spreadsheet downloads.
New issue though -- now it's throwing all of the data into a
single cell in the spreadsheet. I haven't found any messages
dealing with this issue. What could be the problem now?
Everything works as it should in my development environment!
I'm at my wits end on this one! Has anyone broke the code here?
I found my own answer. In all of my attempts to combat the IE
caching issue with SSL, I had added <cfsetting
enablecfoutputonly="yes"> because I had seen it somewhere. I got
rid of this setting and now my spreadsheet exports perfectly.