Re^2: DBI select IN Array

Thank you Hippo. I can see the Perl-related issue. However, your solution produces an empty result, while if I use the following $sql, I can get the expected results. What do you think?

my $sql = "SELECT table FROM tags WHERE tag IN ('red','black')";
my $ID = $dbh->selectall_arrayref ($sql);
[download]

Comment on Re^2: DBI select IN Array Download Code

Replies are listed 'Best First'.
Re^3: DBI select IN Array by hippo (Archbishop) on Feb 20, 2019 at 10:02 UTC
It was a typo in the args on the last line which I've fixed now. If you were running under strict your code would have picked that up. Try that and see how you get on. If you still have problems please consider providing an SSCCE.	[reply]
Re^4: DBI select IN Array by Anonymous Monk on Feb 20, 2019 at 11:55 UTC
Shame on me. Thanks, it works.	[reply]