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/
