X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/bed19453fb654f69ad972911a4533ca89f8ae0c9..ed667cac4097e2f2e62c7dd440eb0977da53b339:/SL/IC.pm diff --git a/SL/IC.pm b/SL/IC.pm index 8341f1888..8f265029f 100644 --- a/SL/IC.pm +++ b/SL/IC.pm @@ -878,7 +878,7 @@ sub all_parts { if ($form->{all}) { $form->{"l_$_"} = 1 for qw(partnumber description unit sellprice lastcost cvar_packaging linetotal); push @where_tokens, "p.partnumber ILIKE ? OR p.description ILIKE ?"; - push @bind_vars, "%$form->{all}%", "%$form->{all}%"; + push @bind_vars, (like($form->{all})) x 2; } # special case insertdate @@ -1342,7 +1342,7 @@ sub create_links { # connect to database my $dbh = $form->get_standard_dbh; - my @values = ('%' . $module . '%'); + my @values = like($module); my $query; if ($form->{id}) {