I just did this and used one of the functions on cflib.org, one of the Query2CSV ones. I did modify it to remove extra line breaks, trim, etc. from the cell data,
Phil On Wed, Dec 9, 2009 at 10:14 AM, AJ Mercer <ajmer...@gmail.com> wrote: > > you will want to use cffile action="append" > > > http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=00000246.htm > > < > http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=00000246.htm > >write > will create the file > append will add to it > > 2009/12/9 <coldfusion.develo...@att.net> > > > > > 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:329008 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
