exporting data to a comma dilimeted file

How about something like the following. This example assumes MS SQL, as other databases may use a different concatenation character than +, but you should get the idea (Oracle uses ||, etc.).

<!---Concatenate the fields in your query into a single CSV "string" per row --->
<cfquery name="your_query" datasource="your_dsn">
SELECT field1+','+
field2+','+
field3+','+
field4 AS your_data
FROM your_table
WHERE whatever
</cfquery>

<!---Add CR and LF to each row returned--->
<cfset query_content=''>
<cfoutput query="your_query">
<cfset "query_content" = query_content & #your_data# & CHR(13) & CHR(10)>
</cfoutput>

<!---Write CSV to file--->
<cffile ACTION="Write"
FILE=#expandpath(".\your_directory\your_filename.csv")#
OUTPUT="#query_content#">

Phil