From a10943b5865f6257d25f428c8a882c43229eb9ae Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Fri, 18 Jan 2008 16:56:44 +0000 Subject: [PATCH] Syntaxfehler in SQL-Query. --- SL/AM.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/SL/AM.pm b/SL/AM.pm index 3ed8e5ddb..3f34e18c7 100644 --- a/SL/AM.pm +++ b/SL/AM.pm @@ -2518,7 +2518,7 @@ sub get_all_warehouses { my $dbh = $form->get_standard_dbh($myconfig); my $query = qq|SELECT w.id, w.description, w.invalid, - (SELECT COUNT(b.description) FROM bin b WHERE b.warehouse_id = w.id) AS number_of_bins, + (SELECT COUNT(b.description) FROM bin b WHERE b.warehouse_id = w.id) AS number_of_bins FROM warehouse w ORDER BY w.sortkey|; -- 2.20.1