Report CSV file

The following is just a demonstration. You can use the concept to do what you want:

<cfsetting showdebugoutput="false">
<cfcontent type="text/csv" reset="true">
<cfheader name="Content-Disposition" value="attachment; filename=example.csv">
<cfscript>
  db = QueryNew("TextField1, NumericField, TextField2", "VarChar, Integer, VarChar");
  queryAddRow(db, [
    {TextField1="abc", NumericField=1, TextField2="def"},
    {TextField1='g"h"i', NumericField=2, TextField2="jkl"},
    {TextField1="mno", NumericField=3, TextField2="pqr"}
  ]);
  for (rowIndex = 1; rowIndex <= db.recordCount; rowIndex++) {
    writeOutput('"');
    writeOutput(replace(db.TextField1[rowIndex], '"', '""', 'all'));
    writeOutput('",');
    writeOutput(db.NumericField[rowIndex]);
    writeOutput(',"');
    writeOutput(replace(db.TextField2[rowIndex], '"', '""', 'all'));
    writeOutput('"');
  if ( rowIndex != db.recordCount )
    writeOutput(',' & chr(13) & chr(10));
}
</cfscript>

The above is the complete text in a cfm file. No HTML is required at all. When you access the file through your browser (for example http://localhost/demo.cfm) your browser will prompt you to save a file called "example.csv" which is a plain text file.

Cheers

Eddie