Seth, good advice on the additional extension as another URL variable. My Internet Explorer is also afflicted with the Netscape MIME problem with PDF files (go figure), and your little trick solved it.
I used www.mypath.com/index.cfm?type=.pdf and it works great. Jeremy -----Original Message----- From: Seth Bienek [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 9:58 AM To: [EMAIL PROTECTED] Subject: RE: Excel Report Question 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 ------------------------------------------------------------------------- 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
