cfwrite HTNL to txt file with weird characters
HI
I have CF 9, try to query from DB with utf-8 chars. it show Ok on web page.
Then we tried to write to txt file so we can download and open the Excel.
the txt file shows &#... chars
Please help. I tried to google but can not find and help.
I really appreaciate.
I will buy you a Starbuck coffee.
<!--- Lets make the file, and put the first row of Column headings in --->
<cffile action="WRITE" file="#f_dir##f_name#" output="CamperType, FullName, LDName, MCNName, CamperID, Photo" addnewline="Yes" charset="windows-1252">
<cfloop query="camperList">
<cffile action="APPEND" file="#f_dir##f_name#" output="#camperTypeName#, #camperFullName#, #Ldname#, #mcnName#, #camperID#, #photoIDFile#" addnewline="Yes" charset="utf-8">
<!--- End the loop here --->
</cfloop>
<br>
<cfoutput>
<a href="reportDownload.cfm?FileName=#absolutefilepath#">Here is the file</a>
</cfoutput>
