A couple of methods I use to output a file from the browser to .txt.<\/p>\n
Write your query as normal. Then use one of the two output methods below.<\/p>\n
CF8 – Output as comma delimited with quotes. Note, without quotes the line does not break properly. CF7 – Output as tilde delimted with line wraps defined. It is important to note that wherever you have line breaks and spaces in your code, you will have linebreaks and spaces in your txt file. This can be a problem if users are trying to upload your data into a database. <\/p>\n","protected":false},"excerpt":{"rendered":" A couple of methods I use to output a file from the browser to .txt. Write your query as normal. Then use one of the two output methods below. CF8 – Output as comma delimited with quotes. Note, without quotes … Continue reading
\n<cfcontent type=\"text\/plain\">
\n<cfheader name=\"content-disposition\" value=\"attachment;filename=yourfilename.txt\">
\n\"Header-numericfield\",\"Header-alphafieldname\"
\n<cfoutput query=\"queryname\">#numericfield#,\"#alphafieldname#\"
\n<\/cfoutput><\/code><\/p>\n
\n<cfcontent type=\"text\/plain\">
\n<cfheader name=\"content-disposition\" value=\"attachment;filename=yourfilename.txt\">
\nHeader-numericfield~Header-alphafieldname~\/n
\n<cfoutput query=\"queryname\">#numericfield#~#alphafieldname#~\/n
\n<\/cfoutput><\/code><\/p>\n