I would definitely use SQL Server DTS (if that is the SQL you mean) to generate the file.
You don't need to map any drives either. Just give SQL and CF the appropriate permissions and you can use \\servername\share\ to access the files. M!ke -----Original Message----- From: gabriel l smallman [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 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216371 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
