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
($form{'type'}, $form{'title'}, $form{'subject'}, $form{'author'},
$form{'source'}, $form{'sourceurl'}, $form{'copy'}, $form{'pullquote'});
$dbh->disconnect();
And here's the error I'm getting:
DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver]String
data, right truncation (SQL-22001)(DBD: st_execute/SQLExecute err=-1) at
editarticle.plx line 23.
(This is MS SQL 7 on Win2K AS)
I only get this error when $form{'copy'} is a "large" block of text. I've
tried changing datatypes and lengths to no avail.
______________________________________
splehP ttocS
rotartsinimdA smetsyS TN
secivreS tenretnI renroKbeW
moc.renrokbew@pttocs
moc.renrokbew.www
______________________________________
