Re: Text file problem

2004-05-20 Thread Pete Ruckelshaus - CFList
Is there a way to programmatically create/delete a file DSN from within CF MX 6.1/Windows?  I didn't think there was... Pete Ben Doom wrote: > I'm assuming that 1) this is a Win server and 2) you have access to it. > > Instead of opening the file directly, try setting up a file DSN.  Then, > y

Re: Text file problem

2004-05-20 Thread Ben Doom
I'm assuming that 1) this is a Win server and 2) you have access to it. Instead of opening the file directly, try setting up a file DSN.  Then, you can let the system handle access of it and pull in records in groups. HTH. --Ben Doom Pete Ruckelshaus - CFList wrote: > Hi, > > I'm writing an

Re: Text file problem

2004-05-20 Thread Pete Ruckelshaus - CFList
ts_ba-bz_4fec.htm > > -Original Message- > From: Pete Ruckelshaus - CFList [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 20, 2004 10:37 AM > To: CF-Talk > Subject: Text file problem > > Hi, > > I'm writing an application that allows our client support re

RE: Text file problem

2004-05-20 Thread Greg Luce
Are you using MSSQL? If so, check out BULK INSERT. http://doc.ddart.net/mssql/sql2000/html/tsqlref/ts_ba-bz_4fec.htm -Original Message- From: Pete Ruckelshaus - CFList [mailto:[EMAIL PROTECTED] Sent: Thursday, May 20, 2004 10:37 AM To: CF-Talk Subject: Text file problem Hi, I'm wr

Re: Text file problem

2004-05-20 Thread Aaron DC
do inserts?) and the O/S & ODBC driver handles the file access for you... HTH Aaron - Original Message - From: Pete Ruckelshaus - CFList To: CF-Talk Sent: Friday, May 21, 2004 12:36 AM Subject: Text file problem Hi, I'm writing an application that allows our client support r

Re: Text file problem

2004-05-20 Thread Thomas Chiverton
On Thursday 20 May 2004 15:36 pm, Pete Ruckelshaus - CFList wrote: >   I'm trying to figure out what the most elegant way is to split these > big files into smaller ones, and do it without killing performance.  Has > anyone done this? You could cfexecute something like split, or use Java file clas

Text file problem

2004-05-20 Thread Pete Ruckelshaus - CFList
Hi, I'm writing an application that allows our client support reps to import customer files of a predefined format into our database.  The CSR uploads (form via CFFILE) the tab-delimited text file to the server, and then I loop through the file contents and insert the data into the database.