X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/bed19453fb654f69ad972911a4533ca89f8ae0c9..7afe92aff55c96742fbffb54e382f17f9fe4d907:/SL/RP.pm diff --git a/SL/RP.pm b/SL/RP.pm index 1154f4eba..a18452e67 100644 --- a/SL/RP.pm +++ b/SL/RP.pm @@ -1521,15 +1521,15 @@ sub payments { my $invnumber; my $reference; if ($form->{reference}) { - $reference = $dbh->quote('%' . $form->{reference} . '%'); + $reference = $dbh->quote(like($form->{reference})); $invnumber = " AND (a.invnumber LIKE $reference)"; $reference = " AND (a.reference LIKE $reference)"; } if ($form->{source}) { - $where .= " AND (ac.source ILIKE " . $dbh->quote('%' . $form->{source} . '%') . ") "; + $where .= " AND (ac.source ILIKE " . $dbh->quote(like($form->{source})) . ") "; } if ($form->{memo}) { - $where .= " AND (ac.memo ILIKE " . $dbh->quote('%' . $form->{memo} . '%') . ") "; + $where .= " AND (ac.memo ILIKE " . $dbh->quote(like($form->{memo})) . ") "; } my %sort_columns = (