don't do a CFFILE ACTION="append", that'll be slow like nothing else. Build the entire file in memory, and then write it with a single CFFILE. If your memory won't handle it, then break it down into chunks (maybe a few hundred or a thousand records each), and write those chunks to the file, rather than each record.
--- Barney Boisvert, Senior Development Engineer AudienceCentral (formerly PIER System, Inc.) [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com > -----Original Message----- > From: Costas Piliotis [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 05, 2003 11:47 AM > To: CF-Talk > Subject: RE: csv files > > > Here. Convert query and filename as you like: > > <cfquery datasource="#application.ds#" name="test"> > select branchid, branchname from tblbranches > </cfquery> > > <cfoutput query="test"> > <cfset myvar = ""> > <cfloop list="#test.columnlist#" index="mycol"> > <cfset myvar = myvar &", "& evaluate("test." & mycol)> > </cfloop> > <cfset myvar = right(myvar, len(myvar) - 1)> > <cffile action="APPEND" file="\\yvrworptest\worp\test.csv" > output="#myvar#"> > </cfoutput> > > -----Original Message----- > From: Michael Tangorre [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 05, 2003 11:31 AM > To: CF-Talk > Subject: csv files > > > Shoot me dead if this has been asked and answered, but pelase respond > nonetheless so that my replacement can jump right in: > > what is the easiest way to create a csv file from a query? What I > have is a > custom tag that takes a runs a query and need to genenrate a csv file and > then save it to the server using cffile. > > > TIA, > > Mike > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
