ble, but it just doesn't seem to work!
I'm 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 Interne
rd does not exist - adding office $officenumber\n";
$sth2->execute($officenumber, $officename) or
error_report("Error inserting new office record:
$DBI::errstr");
}
}
$rcnt++;
}
$sth1->finish;
$sth2->finish;
$rcnt=$rcnt-1;
print
lto:[EMAIL 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
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, but is definitely
size oriented)! Is this still a problem, the message below was dated Tue, 10
Feb 1998.
> From: Ken Whiting <[EMAIL PROTECTED]>
>
> Tim, I posted a m
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
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
($fo
re ('sp_SEARCH_FAQ $keywords');
$sth -> execute;
while (@thedata = $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: R
I am new to DBI and have been trying to find an example of running a stored
procedure in MS-SQL. I have a simple search stored procedure that I need to
pass keywords to and receive a recordset back from. Would anyone mind
terribly giving any examples?
I'd appreciate the help, the DBI docs just s
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
