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.order_to > tal)##tabchar##orders.c_name##tabchar##orders.c_tracking##newline#</cfoutput > > > > > > 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/
