Joseph, Thanks for the response. Could you please explain this code a bit? Also whats the best way to use this code?
James Blaha Joseph Thompson wrote: >This was posted here some time ago. Sorry I don't remember who :-( > ><CFQUERY NAME="GetDocs"...> > SELECT > '"' + RTRIM(FieldA) + '"' + ',' + > '"' + RTRIM(FieldB) + '"' + ',' + > '"' + RTRIM(FieldC) + '"' > AS line > > FROM > table ></CFQUERY> > ><!--- create the file content ----> ><CFSET filecontent = ValueList(GetDocs.line,"#CHR(13)##CHR(10)#")> > ><!--- and save it ---> ><cffile action="APPEND" file="#csvfile#" output="#filecontent#"> > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
