Re: DBI SQLite statement problem with %

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;
[download]

Comment on Re: DBI SQLite statement problem with % Download Code

Replies are listed 'Best First'.
Re^2: DBI SQLite statement problem with % by Your Mother (Archbishop) on Mar 22, 2016 at 19:05 UTC
Agree++. Part of why I like postfix conditionals so well. For the OP, if you're heading down this road, SQL::Abstract is worth looking at. It leads on to things like DBIx::Class. Not everyone agrees ORMs are good for the kids but it's helped me out tremendously during the last decade. :P	[reply]

In Section Seekers of Perl Wisdom