Thank you. I'll give it a try. Where can I find a list of all possible values for the type attribute of the <cfcontent> tag (<cfcontent type="application/vnd.ms-excel" file="#variables.PathAndFileName#" deletefile="No">) so if I wanted to send a text file, word document, or xml document for IE to rendor?
Thanks, Troy "Ledwith, Brian" wrote: > Try this, using the filename and it's location: > > <cfset variables.FileName="TodaysStats.csv"> > <cfset variables.PathAndFileName="C:\Download\TodaysStats.csv"> > > <CFHEADER NAME="Content-Disposition" value="attachment; > filename=#variables.FileName#"> > <cfcontent type="application/vnd.ms-excel" > file="#variables.PathAndFileName#" deletefile="No"> > > ~bgl > > ------------------------------------------------------ > Brian Ledwith > "Stupefying...prodigious...asinine..." --Mac Wellman > Learning Express, LLC. > www.learnatest.com / www.learningexpressonline.com > 900 Broadway NY NY > office: 212.995.2566 x150 > facsimile: 212.995.5512 > mobile: 917.957.9166 > ------------------------------------------------------ > > -----Original Message----- > From: Troy Simpson [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 14, 2002 5:06 PM > To: CF-Talk > Subject: Change FileName from Download.cfm to Download.csv > > I want to query a database with ColdFusion and provide the results to > the user as a comma delimited file with the extention of *.csv so that > the user can open it with Excel. > > Would Someone point me in the right direction on how to do this. > I believe I have to modify the header before sending the result to the > user. > > Thanks, > Troy > > -- > ------------------------- > Troy Simpson > Applications Analyst/Programmer > Microsoft Certified Systems Engineer > Oracle Certified Professional DBA > North Carolina State University Libraries > Campus Box 7111 | Raleigh | North Carolina > ph.919.515.3855 | fax.919.513.3330 > E-mail: [EMAIL PROTECTED] > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
