Hi

It could be whitespace before the beginning of the dump, try adding the
cfcontent attribute reset="yes" which should discard all output
generated up to the cfcontent tag. Also what browser version is this
happening on?

I've always had better results actually using vnd.excel as the mime
type. 


This may help as well:

http://216.239.51.100/search?q=cache:9FRSQ9vbtvYJ:www.houseoffusion.com/
cf_lists/cache/4/8/8207.htm+cf+content+excel+vnd&hl=en&ie=UTF-8

HTH

Kola

>> -----Original Message-----
>> From: Eric Creese [mailto:[EMAIL PROTECTED]
>> Sent: 25 June 2003 19:24
>> To: CF-Talk
>> Subject: RE: Dump to excel error
>> 
>> Nope. If I type the page in the address bar, I get the same error.
>> 
>> -----Original Message-----
>> From: Barney Boisvert [mailto:[EMAIL PROTECTED]
>> Sent: Wednesday, June 25, 2003 11:09 AM
>> To: CF-Talk
>> Subject: RE: Dump to excel error
>> 
>> 
>> Sounds like a glorified 404 error, just with a popup, because you're
>> downloading, rather than opening the page in the browser.  Can you
hit
>> the
>> page with the browser?
>> 
>> Also, you might want to get rid of that META tag, since it has a
>> conflicting
>> content type with your CFCONTENT tag, although that shouldn't prevent
IE
>> from downloading it.
>> 
>> ---
>> Barney Boisvert, Senior Development Engineer
>> AudienceCentral
>> [EMAIL PROTECTED]
>> voice : 360.756.8080 x12
>> fax   : 360.647.5351
>> 
>> www.audiencecentral.com
>> 
>> 
>> > -----Original Message-----
>> > From: Eric Creese [mailto:[EMAIL PROTECTED]
>> > Sent: Wednesday, June 25, 2003 8:39 AM
>> > To: CF-Talk
>> > Subject: Dump to excel error
>> >
>> >
>> > The following is code I use to dump results from a query to
>> > Excel. I have an app that uses this logic right now with no
>> > issue. I am now running the same code pretty much for another app
>> > on a different server.
>> >
>> > Error Message(pop up from IE)
>> > IE cannot download classexceldump.cfm. IE was not able to open
>> > this file form this site. The request site was unavailble or not
>> > found. Try again later.
>> >
>> > <CFHEADER NAME="content-disposition" VALUE="inline;
>> > filename=classroster.xls">
>> >
>> > <cfcontent type="application/ms-excel">
>> >
>> > <CFQUERY NAME="getYRInfo" datasource="#PrimaryDataSource#">
>> >     SELECT class_year
>> >     FROM alumni
>> >     WHERE username = '#session.user#'
>> >  </CFQUERY>
>> >
>> >  <CFQUERY NAME="getclass" datasource="#PrimaryDataSource#">
>> >     SELECT *
>> >     FROM alumni
>> >     WHERE class_year = '#getYRInfo.class_year#'
>> >     AND reunion_news = 'YES'
>> >  </CFQUERY>
>> >
>> > <html>
>> > <head>
>> > <title>Class List</title>
>> > <meta http-equiv="Content-Type" content="text/html;
charset=iso-8859-
>> 1">
>> > </head>
>> >
>> > <body>
>> > <table width="100%" border="1" cellpadding="0" cellspacing="0" >
>> >              <tr align="center" bgcolor="CCCCCC">
>> >                    <td colspan="3"><strong><font size="1"
>> > face=" Arial" >Name</font></strong></td>
>> >                    <td colspan="2"><strong><font size="1"
>> > face=" Arial" >Address</font></strong></td>
>> >            <td><strong><font size="1" face=" Arial"
>> > >City</font></strong></td>
>> >                    <td><strong><font size="1" face=" Arial"
>> > >State</font></strong></td>
>> >            <td><strong><font size="1" face=" Arial"
>> > >Country</font></strong></td>
>> >                    <td><strong><font size="1" face=" Arial"
>> > >Zip</font></strong></td>
>> >                    <td><strong><font size="1" face=" Arial"
>> > >Email Address</font></strong></td>
>> >            <td><strong><font size="1" face=" Arial" >Phone
>> > Number</font></strong></td>
>> >    </tr>
>> >    <cfoutput query="getclass">
>> >    <tr>
>> >            <td ><strong><font size="1" face=" Arial"
>> > >#fname#</font></strong></td>
>> >            <td ><strong><font size="1" face=" Arial"
>> > >#lname#</font></strong></td>
>> >                    <td><strong><font size="1" face=" Arial"
>> > >#mname#</font></strong></td>
>> >                    <td><strong><font size="1" face=" Arial"
>> > >#addr1#</font></strong></td>
>> >                    <td><strong><font size="1" face=" Arial"
>> > >#addr2#</font></strong></td>
>> >            <td><strong><font size="1" face=" Arial"
>> > >#city#</font></strong></td>
>> >                    <td><strong><font size="1" face=" Arial"
>> > >#state#</font></strong></td>
>> >                    <td><strong><font size="1" face=" Arial"
>> > >#country#</font></strong></td>
>> >                    <td><strong><font size="1" face=" Arial"
>> > >#zip#</font></strong></td>
>> >            <td><strong><font size="1" face=" Arial"
>> > >#email#</font></strong></td>
>> >                    <td><strong><font size="1" face=" Arial"
>> > >#phone#</font></strong></td>
>> >    </tr>
>> >    </cfoutput>
>> > </table>
>> >
>> > </body>
>> > </html>
>> >
>> > Eric
>> >
>> 
>>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

                                Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
                                

Reply via email to