cf_query2csv is a quick solution to create csv data.

*** Requirements:
ColdFusion 5, MX and up

*** Usage:
<cf_query2csv query="[queryname you want to convert]"
       result="[csv string result]"
       delimiter="[delimiter, default is comma]"
       linebreak="[linebreak, default is carriage return followed by line feed (chr(13) & chr(10))]"        
       textqualifier="[text qualifier, default is a double quote]"
       columnlist="[list of column to be exported, if empty all columns will be exported]"
       startrow="[the first row to process]"
       endrow="[the last row to process, if 0 all the rest rows will be processed]"
       header="[Text before the CSV data]"
       footer="[Text after the CSV data]"
>           

*** Examples:
For a complete example, please check
http://www.masrizal.com/index.cfm?fuseaction=idea.download_detail&ProductID=cf_query2csv