thank you... however, my bottleneck isnt the file i/o, its the taking of the query object and inserting the comma's in between each value and the cr/lf at the end of a row.
thats the problem. getting the data into a file, is easy and quick. i see, through my test harness, that my bottleneck is that darned query object into csv object... any ideas? tw On 5/16/07, Jon Clausen <[EMAIL PROTECTED]> wrote: > Tony, > > Here's a quick tutorial on using BCP with SQL Server 2000 (with links > to BCP resources on MSDN) to output text files: > > http://www.sqlteam.com/item.asp?ItemID=4722 > > If you want to maintain portability between DBMS' by using Coldfusion > to handle the export workload, Ben Nadel had a good article the other > day on optimizing that process by using the Java string buffer : > > http://www.bennadel.com/blog/679-ColdFusion-Optimizing-Case-Study- > Writing-Orders-To-A-CSV-File.htm > > HTH, > > Jon > > On May 16, 2007, at 3:36 PM, Tony wrote: > > > ok. > > next question. > > how in the heeeeeeeck do i do it in SQL? > > im using sql server 2000. > > i could use sql server 2005. > > > > any and ALL HELP is appreciated. > > > > thanks > > tony > > > > On 5/16/07, Robertson-Ravo, Neil (RX) > > <[EMAIL PROTECTED]> wrote: > >> Best bet is don't do it in ColdFusion at all, let the SQL engine > >> do the work > >> and ref the resultant file. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278452 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
