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] ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
