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/ > --- 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/ --- 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/ ---------------------------------------------------------------------------- This email, together with any attachments, is intended for the named recipient(s) only and may contain privileged and confidential information. If received in error, please inform the sender as quickly as possible and delete this email and any copies from your computer system network. If not an intended recipient of this email, you must not copy, distribute or rely upon it and any form of disclosure, modification, distribution and/or publication of this email is prohibited. Unless stated otherwise, this email represents only the views of the sender and not the views of the Queensland Government. ---------------------------------------------------------------------------- --- 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/ --- 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/
