Re: Truncation Issues with SQL Server Insert Statement

From: Amonotod (amonotod_at_charter.net)
Date: 07/13/04 

To: Tim Bunce <Tim.Bunce@pobox.com>, <dbi-users@perl.org>
Date: Tue, 13 Jul 2004 19:36:09 +0000

> From: Tim Bunce <Tim.Bunce@pobox.com>
> 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________________________________
  _____|_____|_____|_____|_____|_____|_____|_____|

Relevant Pages

  • stored proc from classic asp and ado parameter issue
    ... enters it into sql server database whit float data type fiels. ... whitout friendly HTTP error msg in internet explorer, i got "loop whit out ...
    (microsoft.public.inetserver.asp.db)
  • OVERFLOW error
    ... When I run a ADO query against a SQL Server database it ... I can loop thru all records ... doesnt help. ...
    (microsoft.public.access.externaldata)
  • Overflow - download from SQL
    ... When I run a ADO query against a SQL Server database it ... I can loop thru all records ... doesnt help. ...
    (microsoft.public.access.modulesdaovba)
  • Re: strange question about DropDownList
    ... different data in you SQL Server database than you had in the Access ... HTH, ... > when i used code below and bind with access i could get the resoult what ... Prev by Date: ...
    (microsoft.public.dotnet.framework.aspnet.webcontrols)