I'll second the notion for a DTS package. I've been using them extensively lately to build downloadable subsets of data from SQL into an Access DB and they're FAST! Although I didn't have much luck running a DTS package from CF - I ended up writing an ASP script that handles the DTS package and I call it via CFHTTP and have the ASP script return a status code of success or fail. It's pretty easy and very powerful.
If you're interested I can send you the ASP script to run the DTS package. Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 ************************************************************************ ************* Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] ************************************************************************ ************* -----Original Message----- From: Dan O'Keefe [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 12:43 PM To: CF-Talk Subject: RE: Writing Query Results to a CSV using CFFILE 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 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
