From 8cc4ba47074672d0907a19e71617c9f468b0361e Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Tue, 5 Jun 2007 14:12:41 +0000 Subject: [PATCH] =?utf8?q?Bei=20Artikelsuche=20Gro=C3=9F-/Kleinschreibung?= =?utf8?q?=20ignorieren.?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- SL/IR.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/SL/IR.pm b/SL/IR.pm index 875059bfa..98a53536f 100644 --- a/SL/IR.pm +++ b/SL/IR.pm @@ -1007,7 +1007,7 @@ sub retrieve_item { foreach my $table_column (qw(p.partnumber p.description pg.partsgroup)) { my $field = (split m{\.}, $table_column)[1]; next unless $form->{"${field}_${i}"}; - $where .= " AND lower(${table_column}) LIKE ?"; + $where .= " AND lower(${table_column}) LIKE lower(?)"; push @values, '%' . $form->{"${field}_${i}"} . '%'; } -- 2.20.1