From bd5827d5fcfac8ac311a58c7a399fb0b736ed4b8 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Mon, 8 Dec 2008 20:47:15 +0000 Subject: [PATCH] sales_items_list MySQL 3.xx compatibility fix. --- includes/ui/ui_lists.inc | 5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) diff --git a/includes/ui/ui_lists.inc b/includes/ui/ui_lists.inc index 7b8f503e..a5a5cbf2 100644 --- a/includes/ui/ui_lists.inc +++ b/includes/ui/ui_lists.inc @@ -683,10 +683,9 @@ function sales_items_list($name, $selected_id=null, $all_option=false, ON i.category_id=c.category_id"; if ($type == 'local') { // exclude foreign codes - $sql .= " WHERE NOT i.is_foreign"; + $sql .= " WHERE !i.is_foreign"; } elseif ($type == 'kits') { // sales kits - $sql .= " WHERE NOT i.is_foreign - AND NOT i.item_code=i.stock_id"; + $sql .= " WHERE !i.is_foreign AND i.item_code!=i.stock_id"; } $sql .= " GROUP BY i.item_code"; -- 2.30.2