HI am using SQLite DB and whenever I try to bind the values of parameter into the statement I am getting an error.
Here's the piece of code:
my $sth = $dbh->prepare("SELECT UserId,UserName,CardNo,GroupId,Role,VerifyType FROM
UsersList limit ?,? ");
$sth->bind_param(1, undef,SQL_VARCHAR);
$sth->bind_param(2, undef,SQL_VARCHAR);
$sth->execute($page,$results_per_page);
Here's the error:
ERROR: DBD::SQLite::st execute failed: datatype mismatch at line 68.
Can anybody Please help me out and let me know what datatype am I supposed to put in place of SQL_VARCHAR?