Writing query to a csv file

[coldfusion . developer]

I have a need to write the output from aquery to a csv file without headers.

I've seen many examples where you can write the output from a query to a CSV 
file.  However
most of the examples I've seen require that the file be created first with 
headers and then then
ourput from the query is appended. I've tried to skip the file create and 
header insertion but the
data doesn't write to the csv correctly.  

Any advice?

<cfquery name="get_all" datasource="#datasource#" maxrows="55">
select *
from Employee_main
</cfquery>

<!--- Create the file with column header's. It is crucial that you have all the 
outputed text on one line with no spaces between the comma and the next column 
header.--->
    <cffile action="write"
file="D:\Inetpub\wwwroot\HR\employee\cfmscripts\contacts.csv"
             output="ed_first_name,
             ed_last_name,
             ed_fi_last_name,
             ed_title,
             ed_email,
             ed_reports_to,
             ed_department,
             ed_division,
             ed_location,
             ed_phone_number,
             ed_extension,
             ed_submitted,
             ed_state,
             ed_country,
             ed_zip_code"
             addnewline="yes"> 

 <!--- Output the contents of the export_contacts query --->
    <cfoutput>
        <cfloop query="get_all">
#TRIM(ed_first_name)#,#TRIM(ed_last_name)#,#TRIM(ed_fi_last_name)#,#TRIM(ed_title)#,#TRIM(ed_email)#,#TRIM(ed_reports_to)#,#TRIM(ed_department)#,#TRIM(ed_division)#,#TRIM(ed_location)#,#TRIM(ed_phone_number)#,#TRIM(ed_extension)#,#TRIM(ed_submitted)#,#TRIM(ed_state)#,#TRIM(ed_country)#,#TRIM(ed_zip_code)#
 <BR />       <!--- Append (Insert) the contents of the query into the already 
created CSV file. Make sure that you keep all the output on one line exactly 
like the column header--->
        
 <cffile action="WRITE" 
 file="D:\Inetpub\wwwroot\HR\employee_directory\cfmscripts\contacts555.csv"
output="#TRIM(ed_first_name)#,#TRIM(ed_last_name)#,#TRIM(ed_fi_last_name)#,#TRIM(ed_title)#,#TRIM(ed_email)#,#TRIM(ed_reports_to)#,#TRIM(ed_department)#,#TRIM(ed_division)#,#TRIM(ed_location)#,#TRIM(ed_phone_number)#,#TRIM(ed_extension)#,#TRIM(ed_submitted)#,#TRIM(ed_submitted)#,#TRIM(ed_state)#,#TRIM(ed_country)#,#TRIM(ed_zip_code)#"
 addnewline="yes"> 
        </cfloop>
    </cfoutput>


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329004
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4