If you are building a massive string (without appending to a file) I would suggest using the Java StringBuffer. It creates parts of a string and then creates a full string once at the end... HUGE performance advantage over traditional string concatenation:
<cfset jstrBuffer = CreateObject( "java", "java.lang.StringBuffer" ).Init() /> <cfloop query="qTest"> <cfset jstrBuffer.Append( "this is row: " & qTest.CurrentRow ) /> </cfloop> <cfoutput> #jstrBuffer.ToString()# </cfoutput> ....................... Ben Nadel www.bennadel.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 20, 2006 1:41 PM To: CF-Talk Subject: Export text I need to do a simple download of 100,000 plus records out of SQL. I would like the user to get prompted to save a .txt file They will be using recent versions of IE. I've been playing around with CFHeader and CFContent. It works OK if specify Application/msexcel. Does anyone have any code examples dumping to a text file? Lee ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244286 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
