On Tue, Jul 13, 2004 at 03:32:42PM -0500, Lisa Homstad wrote: > *sigh* > > http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d- > b037-185d0506396c&DisplayLang=en
That is (after fixing the split URL :) the download page for "Microsoft Data Access Components (MDAC) 2.8" so I presume you're saying that upgrading MDAC to 2.8 fixed the problem. Is that right? > It seems to be working fine now. I am so, so, sorry for bothering everyone. No problem. I glad it's fixed and glad you're using execute_array() sucessfully. Tim. > Lisa Homstad > Web Developer > Global Reach Internet Productions > [EMAIL PROTECTED] > 515-296-0792 > http://www.globalreach.com > > > -----Original Message----- > From: Hardy Merrill [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 13, 2004 2:42 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: Truncation Issues with SQL Server Insert Statement > > > The problem with the original question/issue is that the poster did not > include any DBI code. Gathering from Amonotod's comments below, the > issue may be the quoting (or lack of proper quoting) done. > > Original poster: did you use either the "quote" method, or better yet > did you use placeholders?? If you could post some of the DBI code for > your inserts into SQL Server, that might help ;-) > > Hardy Merrill > > >>> amonotod <[EMAIL PROTECTED]> 07/13/04 03:36PM >>> > > 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________________________________ > _____|_____|_____|_____|_____|_____|_____|_____| > >