How can I bind the values of the parameter in the SQL statement using Perl?

Question

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?

brian d foy · Accepted Answer · 2010-10-01 17:57:28Z

5

Looks like you are using bind_param() wrong. Take a look at this example:

use DBI qw(:sql_types);  # Don't forget this

my $sth = $dbh->prepare(q{
    SELECT bar FROM foo GROUP BY bar HAVING count(*) > ?;
});
$sth->bind_param(1, 5, SQL_INTEGER);
$sth->execute();

i.e.: no arguments to execute() and the value goes in the bind_param() call.

edited Oct 1, 2010 at 17:57

brian d foy

134k31 gold badges214 silver badges613 bronze badges

answered Oct 1, 2010 at 11:52

Øyvind Skaar

2,33815 silver badges16 bronze badges

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

Comments

Donal Fellows · Accepted Answer · 2010-10-01 09:57:55Z

1

Limits are integers and not text, so I'd guess SQL_INTEGER might be a thing to try first?

answered Oct 1, 2010 at 9:57

Donal Fellows

139k19 gold badges161 silver badges222 bronze badges

1 Comment

SUSH Over a year ago

I TRIED using SQL_INTEGER Also but the same error exists,i even used use DBI qw(:sql_types); but nothing is working ;-(

J. Ceron · Accepted Answer · 2013-03-27 18:59:37Z

0

my $sql = "INSERT INTO table 
                       (name, age)
           VALUES 
                       ('$name', ?);

$sth = $dbh->prepare($sql);

#if not $age insert NULL value 
$sth->execute($age ? $age : undef);

edited Mar 27, 2013 at 18:59

answered Mar 27, 2013 at 15:38

J. Ceron

1,38512 silver badges8 bronze badges

Collectives™ on Stack Overflow

How can I bind the values of the parameter in the SQL statement using Perl?

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related