> 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________________________________ _____|_____|_____|_____|_____|_____|_____|_____|