Re: Large recordsets turned into text file

Alan, Thanks for nice comments about the UDF and I am glad that it worked for you. I have been using it at my work since some of our dataset are huge and it was taking forever for clients to download a CSV file. Qasim Rasheed On 8/25/05, Alan Rother <[EMAIL PROTECTED]> wrote: > We had the same p

Re: Large recordsets turned into text file

You should use something like a buffered writer to create the file. you can probably createObject("java", ...) to get it working. Look at: http://java.sun.com/j2se/1.5.0/docs/api/java/io/BufferedWriter.html for info on how it works. I don't really have time to play with it today, so, sorry i can

Re: Large recordsets turned into text file

We had the same problem. We found that anything over 5 was crashing our server using the old school cfloop over a variable. Check out cflib.org and search for this QueryToCSV2 It uses JAVA and the toString method. It reduced our export time by about 2000% and now I have

RE: Large recordsets turned into text file

What format do you want it in? CSV? Have you tried CF_Query2CSV http://www.cfcustomtags.com/goto.cfm?LinkID=334 Dave -Original Message- From: gabriel l smallman [mailto:[EMAIL PROTECTED] Sent: Thursday, August 25, 2005 11:10 AM To: CF-Talk Subject: Large recordsets turned into text

RE: Large recordsets turned into text file

llman [mailto:[EMAIL PROTECTED] Sent: Thursday, August 25, 2005 10:10 AM To: CF-Talk Subject: Large recordsets turned into text file Have an app. That needs to turn a query of about 150,000 records into a text file, zip it, send back to user. Using cf to loop and build the text file just wont wor

Large recordsets turned into text file

Have an app. That needs to turn a query of about 150,000 records into a text file, zip it, send back to user. Using cf to loop and build the text file just wont work, it takes forever and often crashes. Someone mentioned a way todo it with php, by invoking a function that converts the record set

Large recordsets turned into text file

Have an app. That needs to turn a query of about 150,000 records into a text file, zip it, send back to user. Using cf to loop and build the text file just wont work, it takes forever and often crashes. Someone mentioned a way todo it with php, by invoking a function that converts the record set