PLEASE TAKE ME OFF ALL OF YOUR EMAIL LIST. I'm getting information shared by all of
you and I should not. THANK YOU
-Original Message-
From: Kevin Shortt [mailto:[EMAIL PROTECTED]
Sent: Friday, June 04, 2004 10:51 AM
To: [EMAIL PROTECTED]
Subject: insertion problem...
Note: cross poste
>
> Hi,
>
> My code just fails to insert the records to the database.
> Anybody can figure out the problem? Thanks in advance.
> Here is the snippet:
> #
> my $dbn="newgene";
> my $dbh=DBI->connect("dbi:ODBC:$dbn",'','')|| die "$DBI::errstr
On Wed, Sep 04, 2002 at 01:36:25PM +0800, Liu Haifeng wrote:
> eval {
> $sth->bind_param( 1, @$_->[0], SQL_VARCHAR );
> $sth->bind_param( 2, @$_->[1], SQL_VARCHAR );
> $sth->bind_param( 3, @$_->[2], SQL_INTEGER );
> $sth->execute() || die "$DBI::errstr\n";
> $dbh->commit() ||
Hi.
- Original Message -
From: "Liu Haifeng" <[EMAIL PROTECTED]>
To: "BAO RuiXian" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, September 04, 2002 5:20 PM
Subject: Re: insertion problem
> I am sorry but I don't know wher
BAO RuiXian wrote:
>Usually it is inside the database connecting command as a parameter, but can
>also be somewhere else. Just search it through your script.
>
>Best
>
>Bao
>
>Liu Haifeng wrote:
>
>
>
>>I am sorry but I don't know where to disable the AutoCommit.
>>
>>Regards
>>Haifeng
>>
>
Usually it is inside the database connecting command as a parameter, but can
also be somewhere else. Just search it through your script.
Best
Bao
Liu Haifeng wrote:
> I am sorry but I don't know where to disable the AutoCommit.
>
> Regards
> Haifeng
--
BAO RuiXian, PROGRAMMER, Project Consult
I am sorry but I don't know where to disable the AutoCommit.
Regards
Haifeng
- Original Message -
From: "BAO RuiXian" <[EMAIL PROTECTED]>
To: "Liu Haifeng" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, September 04, 2002 4:03
Hello,
Liu Haifeng wrote:
>
> #
> where column 3 is the primary key of table clients. Error message:
> "Database error:
> rollback ineffective with AutoCommit enabled at myprogram.pl line 55."
>
I think the error message clearly says tha
