http://www.perlmonks.org?node_id=328686


in reply to DBD::SQLite select syntax problem

Your $key_sel is not quoted.

Use $dbh->quote($key_sel) before executing, or better yet, use placeholders.

my $cmd = "select * from info where key = ?"; my $sth = $dbh->prepare($cmd); $sth->execute($key_sel);

For an explanation of your error, see "common pitfalls" in this tutorial.

 _  _ _  _  
(_|| | |(_|><
 _|