Re: Trouble with parameters and IN query

[Greg McCann]

Oh, nuts. This always happens. After wrestling with the problem for hours, I post on a forum for help then immediately figure out the solution myself!

I almost had it right with this:

my $user_supplied_value = '2,3';
$sth = $dbh->prepare(qq( select * from ip where id in (?) ));
$sth->bind_param(1, $user_supplied_value, { TYPE => 'SQL_INTEGER' });
$sth->execute() or print $sth->errstr, "<br>\n";

What I was actually supposed to do was this:

use DBI qw(:sql_types);
my $user_supplied_value = '2,3';
$sth = $dbh->prepare(qq( select * from ip where id in (?) ));
$sth->bind_param(1, $user_supplied_value, { TYPE => SQL_INTEGER });
$sth->execute() or print $sth->errstr, "<br>\n";

Note that "TYPE => SQL_INTEGER" instead of "TYPE => 'SQL_INTEGER'".

It seems to be working now. <sigh>

I hope this helps someone.


Greg M.