Re: DBD::SQLite

[KAWAI,Takanori]

----- Original Message -----
From: "Matt Sergeant" <[EMAIL PROTECTED]>
To: "KAWAI,Takanori" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, February 19, 2002 6:45 PM
Subject: Re: DBD::SQLite


> On Tue, 19 Feb 2002, KAWAI,Takanori wrote:
(snip)
> > It works almost fine.
> > But unfortunately, it makes a error when I call execute twice on the
> > same statement handle.
>
> OK, new release out - http://axkit.org/download/DBD-SQLite-0.03.tar.gz
Well, it occurs "Segmentation fault" with 2 placeholders.
A placeholder not occurs error but it makes warnings.

[Script]
use strict;
use DBI;
unlink "foo";
my $dbh = DBI->connect("dbi:SQLite:dbname=foo", "", "",
  {AutoCommit => 0, RaiseError => 1});
$dbh->do("CREATE TABLE MST (id, lbl)");
$dbh->do("CREATE TABLE TRN (no, id, qty)");
my $sth1 = $dbh->prepare(q{INSERT INTO MST VALUES(0, ?)});
$sth1->trace(9);
$sth1->execute('ITEM2');
my $sth2 = $dbh->prepare(q{INSERT INTO MST VALUES(?, ?)});
$sth2->trace(9);
$sth2->execute(2, 'ITEM2');
$dbh->rollback;
$dbh->disconnect;

[kawait@lins t]$ perl -w t1.pl
    DBI::st=HASH(0x8181a64) trace level set to 9 in DBI 1.20-nothread
    -> execute for DBD::SQLite::st (DBI::st=HASH(0x8116fa4)~0x8181a64
'ITEM2')
Use of uninitialized value at t1.pl line 10.
Use of uninitialized value at t1.pl line 10.
    <- execute= -1 at t1.pl line 10
    DBI::st=HASH(0x8181a28) trace level set to 9 in DBI 1.20-nothread
    -> execute for DBD::SQLite::st (DBI::st=HASH(0x8125918)~0x8181a28 2
'ITEM2')
Use of uninitialized value at t1.pl line 13.
Segmentation fault (core dumped)

==============================================
Kawai, Takanori(Hippo2000)
   Mail: [EMAIL PROTECTED] [EMAIL PROTECTED]
   http://member.nifty.ne.jp/hippo2000
==============================================