> From: Tim Bunce <[EMAIL PROTECTED]>
> Date: 2004/07/13 Tue PM 06:38:51 GMT
> I have been writing a perl script that takes a row of 43 fields, splits on a tab,
> and performs an
> execute_array into an SQL Server database, all in a loop. The insert statement
> works fine, it doesn't
> generate any errors as far as I can tell, and all the data gets inserted into the
> database. The only
> problem is, a few of the fields are truncated.
I was having issues similar to this, until I switched to DBD::CSV to parse
my input files and started using quote() instead of s///... Works great
now. So, "Thanks, Jeff and Jochen!"...
HTH,
amonotod
--
`\|||/ amonotod@ | subject line:
(@@) charter.net | no perl, no read...
ooO_(_)_Ooo________________________________
_____|_____|_____|_____|_____|_____|_____|_____|
