What creating a DTS package which accepts a few parameters from CF. The DTS would run the query, and export it also, like lickety split too.
Dan -----Original Message----- From: Wendy Copley [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 6:25 PM To: CF-Talk Subject: Re: Writing Query Results to a CSV using CFFILE [EMAIL PROTECTED] writes: >Which database are you using? We're on SQL Server 7.0. I should add that the query itself doesn't seem to be the problem -- it returns in a matter of seconds. The lag is almost certainly happening in the process of looping through the query results and appending each line to the file. Thanks. _______________ Wendy Copley Web Engineer [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
