From 3634aa28790d3a080cf3b7878149c6c5eb62ce16 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Thu, 16 Aug 2007 15:15:54 +0000 Subject: [PATCH] SQL-Fehler "description is ambiguous" --- SL/IC.pm | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) diff --git a/SL/IC.pm b/SL/IC.pm index 241ba5870..38a30e008 100644 --- a/SL/IC.pm +++ b/SL/IC.pm @@ -892,10 +892,14 @@ sub all_parts { } } + my %simple_filter_table_prefix = ( + description => 'p.', + ); + foreach (@simple_filters, @makemodel_filters, @invoice_oi_filters) { next unless $form->{$_}; $form->{"l_$_"} = '1'; # show the column - push @where_tokens, "$_ ILIKE ?"; + push @where_tokens, "$simple_filter_table_prefix{$_}$_ ILIKE ?"; push @bind_vars, "%$form->{$_}%"; } -- 2.20.1