: jon hall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 9 January 2003 2:43 AM
To: CF-Talk
Subject: Re: Test CSV
I did the same thing not to long ago, importing emails from an ACT
exported list. I ended up using reading the uploaded file via an ODBC
Text DSN. This lets the ODBC driver handle any
I did the same thing not to long ago, importing emails from an ACT
exported list. I ended up using reading the uploaded file via an ODBC
Text DSN. This lets the ODBC driver handle any corrupted data, and
turns the csv into a query automagically.
All I did was manually create a ODBC Text DSN to get
ddress
**
Kevin Parker
Web Services Manager
WorkCover Corporation
[EMAIL PROTECTED]
www.workcover.com
p: 08 82332548
f: 08 82332000
m: 0418 806 166
**
-Original Message-
From: Jerry Johnson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 8 January 2003 9:01 AM
To: CF-Ta
548
f: 08 82332000
m: 0418 806 166
**
-Original Message-
From: Jerry Johnson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 8 January 2003 9:01 AM
To: CF-Talk
Subject: Re: Test CSV
First, wrap the read and processing in a , so that even if the data
is bad, you won't break.
Next,
First, wrap the read and processing in a , so that even if the data is bad, you
won't break.
Next, you might want to create a little CF app that reads the file and looks for
patterns, and if an error is thrown, stops the processing.
for the error checking, a simple listlen() for each line could
I have a CSV file that I want to read into variable (see below). Before
doing so I think I should test the construction of the file to ensure that
its valid otherwise I think there is a risk of the process falling over if
it encounters a badly constructed file somewhere a long the way. How can I
te
6 matches
Mail list logo