in reply to Re^2: Perl Mysql DBI, using placeholders with unknown variable count
in thread Perl Mysql DBI, using placeholders with unknown variable count

If status is a column name, you may not quote it with $dbh->quote() or by using it as a placeholder - you must use $dbh->quote_identifier(). That is the problem, not the data type of the int.

Sorry if I got that wrong in my first example.

The rule is simply $dbh->quote_identifier() for column names and placeholders (?) for data.

Perl 6 projects - links to (nearly) everything that is Perl 6.