troubleshooting Question

COLDFUSION EXPORT TO EXCEL - WRONG FILENAME

Avatar of wvalencia
wvalencia asked on
Windows OSColdFusion Language
1 Comment1 Solution366 ViewsLast Modified:
I am trying to export some data into a excel spreadsheet using ColdFusion. The export works perfect but always the export file is called like "index.cfm" instead my temp file which is tempfile.xls. Below is the code I am using.
QUERY COMES FIRST
<CFSET tempfile = "C:\temp\exptemp.xls">
<CFSET output = "">
<CFSET output = output & "Card_Name      Lot_Number      Seq_Number      Face_Value      Pin_Cost FU_DateTime">
<CFFILE ACTION="WRITE"
      FILE="#tempfile#"
      OUTPUT="#output#">
<CFLOOP QUERY="exp_fu">
      <CFSET output = "">
      <CFSET output = output & "#card_brand_name#      #lot_num#      #seq_num#      #face_value#      #customer_cost#      #dateformat(fu_date, 'mm/dd/yy HH:mm:ss')#">
<CFFILE ACTION="APPEND" FILE="#tempfile#" OUTPUT="#output#">
</CFLOOP>
<CFCONTENT TYPE="application/msexcel" FILE="#Tempfile#">

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 1 Comment.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros