Here's a snippet of my code:
my $dbh = DBI-connect('dbi:ODBC:MYDSN', 'user', 'pass',{RaiseError = 1,
AutoCommit = 1});
$sth = $dbh-prepare
("INSERT INTO ARTICLES (ARTICLE_TYPE, TITLE, SUBJECT, AUTHOR, SOURCE,
SOURCE_URL, COPY, PULLQUOTE) VALUES (?, ?, ?, ?, ?, ?, ?, ?)");
$sth-execute
check these values out. Read the doc about them.
Is the column a long varchar?
#
print "LongReadLen=$dbh-{LongReadLen}\n";
#
print "LongTruncOk=$dbh-{LongTruncOk}\n";
$dbh-{LongReadLen}=5000;
HTH
bob
Scott Phelps wrote:
Here's a snippet of my code:
my $dbh =
Phelps
Cc: [EMAIL PROTECTED]
Subject: Re: Error when inserting large amounts of text
check these values out. Read the doc about them.
Is the column a long varchar?
#
print "LongReadLen=$dbh-{LongReadLen}\n";
#
print "LongTruncOk=$dbh-{LongTruncOk}\n";
$dbh-{LongRe
PROTECTED]]
Sent: Thursday, April 12, 2001 1:57 PM
To: [EMAIL PROTECTED]
Subject: RE: Error when inserting large amounts of text (update)
Scott Phelps writes:
I just found the following in an archive (I believe of this list) and it
sounds like my problem exactly (not sure of byte length
