using Activestate Perl 5.6.1 build 626 on Win2k with the latest
MSSQLReporter (1.00) from Activestate's PPM repository against a MS-SQL 7.0
database.
Thanks in advance for any help,
Scott Phelps
[EMAIL PROTECTED]
Webkorner Internet Services
---
[ This E-mail scanned for viruses
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
The docs say that those values are for "fetching only", and setting them
seems to have no effect on my insert.
Is there any character limit on an insert?
ScottP
-Original Message-
From: Robert Davis [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 12:18 PM
To: Scott
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
ata = $sth - fetchrow_array) {
print "@thedata";
}
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 03, 2001 10:59 AM
To: [EMAIL PROTECTED]
Subject: Re: Running a stored procedure
Hi,
Scott Phelps wrote:
I am new to DBI and have
Here's what doesn't work:
my $dbh=DBI-connect('dbi:ODBC:scottp', 'user', 'pass',
{RaiseError = 1,
AutoCommit = 1}
) || errorhandler("Database connection error: $DBI::errstr");
$sth=$dbh-prepare("SELECT $content_field FROM $content_table WHERE