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
