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/
