exporting data to a comma dilimeted file

[catbollu@msn.com]

Is there a way with coldfusion to take data and export to a comma delimited file. I would use excel but too much data.

[durango]

You could use the CFCONTENT tag to do something like this:


<cfsilent>
<cfquery datasource="MyDatasource" name="MyQuery">
select * from table
</cfquery>
</cfsilent><cfcontent type="text/csv"><cfheader name="Content-Disposition" value="attachment; filename=export.csv">
<cfoutput query="MyQuery">#column1#,#column2#,#column3##Chr(13)#</cfoutput>