in reply to DBI SQLite statement problem with %
I want to avoid to have 2 different contructions of $selection...Don't avoid it, don't worry about it. Just do it, e.g.:
my @filter; push @filter, "tag1 like '$value1'" if $value1; push @filter, "tag2 like '$value2'" if $value2; $sql .= "WHERE " . join(" AND ", @filter) if @filter;
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: DBI SQLite statement problem with %
by Your Mother (Archbishop) on Mar 22, 2016 at 19:05 UTC |
In Section
Seekers of Perl Wisdom