Oliver, Just tried this with MX + SSL +IE6 on XP workstation and worked fine:
<CFQUERY NAME="GetEmp" DATASOURCE="Intranet"> SELECT * FROM ORG_EMPLOYEE WHERE status = 0 </CFQUERY> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>Untitled</title> </head> <body> <CFHEADER NAME="Content-Disposition" VALUE="inline; filename=emp.xls"> <CFCONTENT TYPE="application/vnd.ms-excel"> <table> <tr> <td>Fname</td> <td>lname</td> </tr> <CFOUTPUT QUERY="GetEmp"> <tr> <td>#FNAME#</td> <td>#LNAME#</td> </tr> </CFOUTPUT> </table> </body> Frank Mamone ----- Original Message ----- From: "olivier" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, September 11, 2002 1:05 PM Subject: CFHEADER/CFCONTENT excel + serverMX + SSL > Hello All, > > > Here is a an interesting issue ... > > We used to have the following 2 lines of code work just great to open a > TABLE-based report in Excel with any IE version and CFserver5: > > <CFHEADER NAME="content-disposition" > VALUE="inline/attachment;filename=""SHIPMENTREPORT.XLS"""> > <CFCONTENT TYPE="application/vnd.ms-excel" RESET="yes"> > > After migrating to Coldfusion Server MX, this is not working anymore with > any IE (actually it only works with one IE5.5 in the whole company, > but can't find out where the configuration difference could be). > > It comes up with the message "Internet Explorer cannot > download...ex.cfm?action=report&type=ship". It works fine with Netscape > though. > > I tried to use another version provided on BF's book, but still have the > exact same issue. > <CFCONTENT TYPE="application/msexcel"> > <CFHEADER NAME="Content-Disposition" VALUE="filename=sreport.xls"> > > Now, if I change the URL from https to http, it works fine on IE !!... > Strange hu ? But the https version used to work just fine with the same cfm > code on CF Server 5, and any version of IE ! > > After playing around with it, it looks like excel is trying to open the file > named "https://the.site/file.cfm?action=theaction"; instead of having IE > downloading the > content first, and then handing it over to excel with the filename specified > in the CFHEADER ... > > I tried: > * changing the settings on the Windows File Types, forcing download, or > browse in the same window, etc... didn't help > * looked over the settings of IE 5.5 on the only computer where this work... > couldn't find anything... > * tried to remove the extension on the "filename=" in the CFHEADER, didn't > work... > * imported the SSL CA certificate on the workstation, didn't help... > > Conclusion so far: > CFserver5 + HTTP + IE = no problem > CFserver5 + HTTPS + IE = no problem > CFserverMX + HTTP + IE = no problem > CFserverMX + HTTPS + IE = problem > All tests have been done on Win2K & XP workstations. > > Anybody have an idea ? > > > Thanks so much !!! > > > Olivier. > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
