This should still work, _unless_ you are setting any no-cache controls in the http header. If you are setting the cache-control to no-cache in the header, then you will get the described problem in any Microsoft Office document (doc, xls etc).
See this: http://support.microsoft.com/?kbid=316431 Cheers, Mark > Let me add to that. I have just worked out that the problem is caused by > SSL. If the address is http://blah.blah.blah it works fine. If I change it > to https://blah.blah.blah it errors. Might have to move this cfm download > page to an unsecured section. > > Brian > > -----Original Message----- > From: Knott, Brian > Sent: Tuesday, 17 June 2003 8:55 AM > To: CFAussie Mailing List > Subject: [cfaussie] Re: Exporting to excel > > > I can't its an image and I cant attach it. It just says > > 'Internet explorer can not download...my file > Internet Explorer was unable to open this internet site. The requested site > is either unavailable or can not be found. Please try again later.' > > Brian > > -----Original Message----- > From: Taco Fleur [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 17 June 2003 8:51 AM > To: CFAussie Mailing List > Subject: [cfaussie] Re: Exporting to excel > > > > It would help if you send the error you are getting... > > -----Original Message----- > From: Knott, Brian [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 17 June 2003 8:49 AM > To: CFAussie Mailing List > Subject: [cfaussie] Re: Exporting to excel > > > Phil, > I get an explorer error saying that it can not download the > file. > Says it cant be found. > > Brian > > -----Original Message----- > From: Phil Evans [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 17 June 2003 8:47 AM > To: CFAussie Mailing List > Subject: [cfaussie] Re: Exporting to excel > > > Hi Brian, > > Can you expand on what "stopped working" means? > > Phil. > > ----- Original Message ----- > From: "Knott, Brian" <[EMAIL PROTECTED]> > To: "CFAussie Mailing List" <[EMAIL PROTECTED]> > Sent: Tuesday, June 17, 2003 8:24 AM > Subject: [cfaussie] Exporting to excel > > > > I have some code that exports to an excel document. Problem is that > it > has > > stopped working. Any ideas > > > > > > > > <cfsetting enablecfoutputonly="Yes"> > > > > <CFQUERY NAME="orders" DATASOURCE="#application.maindatasource#" > > username="#Config.DBLogin#" password="#Config.DBPWD#"> > > SELECT *, company.name as c_name, company.tracking as c_tracking > > FROM orders, company > > WHERE approved = 'yes' and processed = 'Yes' AND (date_time >= > > '#url.start_date#') AND (date_time <= '#url.end_date#') and > > orders.company_id = company.id > > ORDER BY order_no DESC > > </cfquery> > > > > <cfheader name="Content-Disposition" value="filename=all_orders.xls"> > > <cfoutput>Processed Buy Backs from #dateformat(url.start_date,'d mmmm > > yyyy')# to #dateformat(url.end_date,'d mmmm > yyyy')##newline#</cfoutput> > > <cfoutput>Order Number#TabChar#Date Of Order#TabChar#Date Of > > Approval#TabChar#Created > By#TabChar#Amount#TabChar#Company#TabChar#Tracking > > Number#newline#</cfoutput> > > > > <cfloop query="orders"> > > > > <cfoutput>#orders.order_no##tabchar##dateformat(orders.date_time,'d > mmm > > yyyy')##tabchar##dateformat(orders.approved_date,'d mmm > > > yyyy')##tabchar##orders.user_fullname##tabchar##dollarformat(orders.orde > r_to > > > tal)##tabchar##orders.c_name##tabchar##orders.c_tracking##newline#</cfou > tput > > > > > > > > > > > Brian Knott > > QANTM Studio > > Senior Database Developer > > Ph (07) 30174331 > > Mob 0407572127 > > > > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
