Hi Palyne,
ColdFusion will not parse .xls files.
You need to rename the template:
{path}/UserTracking01.cfm?trackuid=373
Also, in addition to using cfcontent to pass a MIME type, I've found it necessarry in
the past to end the URL with ".xls" for Netscape to open the file properly. So you
may append another (unused) variable for this purpose:
{path}/UserTracking01.cfm?trackuid=373&file=UserTracking01.xls
Hope this helps,
Seth
"The poet is in command of his fantasy, while it is exactly the mark of the neurotic
that he is possessed by his fantasy." -Lionel Trilling, The Liberal Imagination (1950)
-----------------------------------
Seth Bienek
Digitaris Technologies, Inc.
tel (972) 690-4131, ext. 103
fax (972) 690-0617
icq 7673959
-----------------------------------
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Palyne Gaenir
> Sent: Tuesday, October 02, 2001 8:03 AM
> To: [EMAIL PROTECTED]
> Subject: Excel Report Question
>
>
> I have a very simple excel report. I clearly don't understand how to
> make these. I've done one previously, and I copied it and just
> changed the query value and columns, but it just doesn't work. When
> I click to go to the report (to go to the excel sheet which should
> query and display the report), I just get the excel sheet with the
> query in it like it's text. What am I doing wrong?
>
> In the spreadsheet itself, it says (from top left cell):
> <cfquery name="selectall" datasource="#odbcd#">
> select trackid,trackstamp from tracker
> where trackuid = #trackuid#
> order by tracklogin,trackstamp</cfquery>
> <cfcontent type="application/vnd.ms-excel" reset="yes">
> "trackuid" trackstamp
> <cfoutput query="selectall">"#Trim(selectall.trackuid)#"
> "#Trim(selectall.trackstamp)#"
> </cfoutput>
>
> {Where the cfcontent and two column names are on one row, but the
> cfcontent tag is in the left column, and the names in the next two;
> where the cfoutput is on one row, with the cfoutput tag in the left
> column, and the two values in the next two columns; where the
> /cfoutput close tag is on the next row down}
>
> To get to the report I have a simple link that says:
> {path}/UserTracking01.xls?trackuid=373
>
> I would greatly appreciate any input on this. I think it's a pretty
> simple thing but I must misunderstand something fundamental.
>
> Thanks,
> Palyne
>
>
> -------------------------------------------------------------------------
> This email server is running an evaluation copy of the MailShield anti-
> spam software. Please contact your email administrator if you have any
> questions about this message. MailShield product info: www.mailshield.com
>
> -----------------------------------------------
> To post, send email to [EMAIL PROTECTED]
> To subscribe / unsubscribe: http://www.dfwcfug.org
>
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
