mg9176 has asked for the wisdom of the Perl Monks concerning the following question:
I'm having a bit of trouble with a parameterized query - mysql as the datasource.
my $sql = 'SELECT something FROM atable WHERE data in (?);'; my $sth = $dbh->prepare($sql); my $rv = $sth->execute($data);
That all works fine and dandy, however if $data is something like
my $data = "1,2,3,4,5,6";
only the first value is passed into the query. Thoughts on a remedy?