Skip Menu |

This queue is for tickets about the DBD-SQLite CPAN distribution.

Report information
The Basics
Id: 18878
Status: resolved
Priority: 0/
Queue: DBD-SQLite

People
Owner: Nobody in particular
Requestors: cyril.scetbon [...] free.fr
Cc:
AdminCc:

Bug Information
Severity: Critical
Broken in: 1.12
Fixed in: (no value)

Attachments


Subject: Selectrow_array() with prepared statement doesnt work
calling more than one time selectrow_array for a prepared statement throws error : DBD::SQLite::db selectrow_array failed: not an error(21) at dbdimp.c line 372 below is a sample script : use DBI; $dbh= DBI->connect("dbi:SQLite:dbname=./storage.db",undef,undef,{ RaiseError => 1, AutoCommit => 1 }); $sth_search_channel_in_standby = $dbh->prepare("select a from mytable where value=?"); $dbh->selectrow_array($sth_search_channel_in_standby,undef,'TEST'); $dbh->selectrow_array($sth_search_channel_in_standby,undef,'TEST');
From: Srand
Le Sam. Avr. 22 15:07:57 2006, guest a écrit : Show quoted text
> calling more than one time selectrow_array for a prepared statement > throws error : > > DBD::SQLite::db selectrow_array failed: not an error(21) at dbdimp.c > line 372 > > below is a sample script : > > use DBI; > > $dbh= DBI->connect("dbi:SQLite:dbname=./storage.db",undef,undef,{ > RaiseError => 1, AutoCommit => 1 }); > $sth_search_channel_in_standby = $dbh->prepare("select a from mytable > where value=?"); > $dbh->selectrow_array($sth_search_channel_in_standby,undef,'TEST'); > $dbh->selectrow_array($sth_search_channel_in_standby,undef,'TEST');
patch updated from http://rt.cpan.org/Public/Bug/Display.html?id=15756 sources for DBD::SQLite version 1.12
Download DBD-SQLite-1.12-patch
application/octet-stream 2.3k

Message body not shown because it is not plain text.

Will be fixed in 1.13.