Error while running sql statement on a sqlite3 db using Perl DBI

Question

I am trying to run a select statement to a sqlite3 database using Perl DBI. The following is the code:

my $dbh = DBI->connect( "DBI:SQLite:dbname=./GenBankData.db" , "" , "" , { PrintError => 0 , RaiseError => 1 } );
    my $Sql = 'select AccessionQueryResultID, AccessionNumber, Definition from AccessionQueryResult';
    my $sth = $dbh->prepare( $Sql )  or die "Couldn't prepare statement: " . $dbh->errstr;;
    $sth->execute( $Sql) or die "Couldn't execute statement: " . $dbh->errstr;

But I am getting the following error: DBD::SQLite::st execute failed: called with 1 bind variables when 0 are needed at /home/mysite.cgi line 33

I have checked that the database and table exist and the same query works fine if I used the sqlite3 command line to run the query.

Thanks

ikegami · Accepted Answer · 2013-05-05 03:24:59Z

1

$sth is a statement handle. It represents the SQL statement/query, so having to provide the SQL statement to the object again makes no sense.

The args $sth->execute expects are values needed to fill in replaceable parameters (?) in the query.

my $sth = $dbh->prepare("INSERT INTO MyTable VALUES (?, ?)");
$sth->execute(1, "a");
$sth->execute(2, "b");
$sth->execute(3, "c");

In your case, since your query doesn't use any replaceable parameters, you should not pass any args to execute.

$sth->execute();

answered May 5, 2013 at 3:24

ikegami

391k17 gold badges291 silver badges555 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Joel · Accepted Answer · 2013-05-05 03:15:09Z

1

You're calling the execute command with incorrect parameters. You've already setup the SQL statement in the previous line, you don't need to do it again. Try this instead:

$sth->execute() or die "Couldn't execute statement: " . $dbh->errstr;

answered May 5, 2013 at 3:15

Joel

3,4932 gold badges27 silver badges33 bronze badges

1 Comment

ikegami Over a year ago

Nit: die "Couldn't execute statement: " . $dbh->errstr; will never get executed because he's using RaiseError.

Collectives™ on Stack Overflow

Error while running sql statement on a sqlite3 db using Perl DBI

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related