[DBD-SQLite] substr w/ two parameters

Jesse Erdmann jerdmann at umn.edu
Fri Feb 11 21:01:07 GMT 2011


Is there a quick fix to allow substr to be called with two parameters
instead of three?  Sometime in 3.5 the official SQLite distribution
made the third parameter optional and it looks like there is code
within the sqlite3.c that makes queries using that form of the
function.  However, when I execute a SQL statement in my Perl code
using either DBD::SQLite 1.31 or 1.32.1 I get an error saying prepare
failed and that substr was being called with the wrong number of

Using the same query in the sqlite3 command line utility executes
appropriately.  Thanks!

Jesse Erdmann
Bioinformatics Analyst
Masonic Cancer Center
University of Minnesota
jerdmann at umn.edu

jesse at jesseerdmann.com
Twitter: http://twitter.com/jesseerdmann

More information about the DBD-SQLite mailing list