Re: Writing query to a csv file

2009-12-09 Thread Phillip Duba
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 wrote: > > you will want to use cffile action="append" > > > http://livedocs.adobe.

RE: Writing query to a csv file

2009-12-09 Thread Mark Kruger
Well.. The code below would uh... Create the same file over and over with only the last row... Unless I'm reading it wrong ;) What you needs is something like ##TRIM(ed_first_name)#,#TRIM(ed_last_name)#,#TRIM(ed_fi_last_name)#,#TRIM(ed _title)#,#TRIM(ed_email)#, And so on You can't us

Re: Writing query to a csv file

2009-12-09 Thread AJ Mercer
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=0246.htm