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 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 in ram to a text file and then zips and send back. But we are stuck doing it on box with mx 6.0. Looked at having sql generate the file, but trying to avoid mapping drives to move it around. Anyone got an clever ideas? gabe ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216374 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
