RE: csv files

2003-06-06 Thread Costas Piliotis
al Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 12:44 PM To: CF-Talk Subject: RE: csv files However, do NOT do that for very large (50,000+ records) reports. Write each line at a time. It may be counter-intuitive, but apparently, appending data to a

RE: csv files

2003-06-06 Thread Barney Boisvert
nal Message- > From: Tony Schreiber [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 05, 2003 12:44 PM > To: CF-Talk > Subject: RE: csv files > > > However, do NOT do that for very large (50,000+ records) reports. Write > each line at a time. It may be counter-intuitive,

Re: csv files

2003-06-06 Thread CF Dude
Here's how I've done it before Download #csvName# There was a problem writing #csvText# to a file > > -Original Message- > > From: Costas Piliotis [mailto:[EMAIL PROTECTED] > > Sent: Thursday, June 05, 2003 11:47 AM > > To:

RE: csv files

2003-06-06 Thread Tony Schreiber
is [mailto:[EMAIL PROTECTED] > > Sent: Thursday, June 05, 2003 11:47 AM > > To: CF-Talk > > Subject: RE: csv files > > > > > > Here. Convert query and filename as you like: > > > > > > select branchid, branchname from tblbranches > > > &

Re: csv files

2003-06-06 Thread jon hall
Are you using SQL Server? If so...there is a very easy, very quick way using DTS. http://www.pengoworks.com/index.cfm?action=articles:spExecuteDTS -- jon mailto:[EMAIL PROTECTED] Thursday, June 5, 2003, 2:31:20 PM, you wrote: MT> Shoot me dead if this has been asked and answered, but pelase r

RE: csv files

2003-06-06 Thread Barney Boisvert
mailto:[EMAIL PROTECTED] > Sent: Thursday, June 05, 2003 11:47 AM > To: CF-Talk > Subject: RE: csv files > > > Here. Convert query and filename as you like: > > > select branchid, branchname from tblbranches > > > > > > >

RE: csv files

2003-06-06 Thread Costas Piliotis
Here. Convert query and filename as you like: select branchid, branchname from tblbranches -Original Message- From: Michael Tangorre [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 11:31 AM To: CF-Talk Subject: