From a5501b166388f169f232af20d911d79528f2f5c5 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Tue, 5 Jun 2007 13:59:14 +0000 Subject: [PATCH] =?utf8?q?Nur=20die=20Lieferanten=20und=20H=C3=A4ndler=20z?= =?utf8?q?ur=C3=BCckliefern,=20die=20nicht=20'ung=C3=BCltig'=20markiert=20?= =?utf8?q?sind.?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- SL/Form.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/SL/Form.pm b/SL/Form.pm index a1e6a4d9d..dbffe1ff7 100644 --- a/SL/Form.pm +++ b/SL/Form.pm @@ -1697,7 +1697,7 @@ sub _get_customers { $key = "all_customers" unless ($key); - my $query = qq|SELECT * FROM customer ORDER BY name|; + my $query = qq|SELECT * FROM customer WHERE NOT obsolete ORDER BY name|; $self->{$key} = selectall_hashref_query($self, $dbh, $query); @@ -1711,7 +1711,7 @@ sub _get_vendors { $key = "all_vendors" unless ($key); - my $query = qq|SELECT * FROM vendor ORDER BY name|; + my $query = qq|SELECT * FROM vendor WHERE NOT obsolete ORDER BY name|; $self->{$key} = selectall_hashref_query($self, $dbh, $query); -- 2.20.1