jon. interested...if you can dig it up, without too much hassle....thanks!!
tony -----Original Message----- From: jon hall [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 8:22 PM To: CF-Talk Subject: Re: Writing Query Results to a CSV using CFFILE Great, this would be a job for the database not CF imo...create a DTS package that writes out the csv file. Then either fire the DTS via an SP, or use the DTS Object Model to execute. This can be a bit complex, but not overly, and the DTS should be able to complete an export of 150k lines in a few seconds, quite an improvement from 30 minutes :) I've made a lengthy posting on how to do this in the past, and I think I can dig it up if you are interested. -- jon mailto:[EMAIL PROTECTED] Tuesday, March 11, 2003, 6:25:23 PM, you wrote: WC> [EMAIL PROTECTED] writes: >>Which database are you using? WC> We're on SQL Server 7.0. WC> I should add that the query itself doesn't seem to be the problem -- it WC> returns in a matter of seconds. The lag is almost certainly happening in WC> the process of looping through the query results and appending each line WC> to the file. WC> Thanks. WC> _______________ WC> Wendy Copley WC> Web Engineer WC> [EMAIL PROTECTED] WC> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
