From 88eb7dd44f44912690089a4c4523e1fd243f6c41 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Fri, 20 Apr 2007 07:15:47 +0000 Subject: [PATCH] Fixed bug no 1703888 Apostrophes and other unescaped characters + another suppliers GL accounts SQL error that was detected. --- gl/manage/gl_accounts.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/gl/manage/gl_accounts.php b/gl/manage/gl_accounts.php index 6e30959..9ff0fa7 100644 --- a/gl/manage/gl_accounts.php +++ b/gl/manage/gl_accounts.php @@ -144,7 +144,7 @@ function can_delete($selected_account) OR sales_discount_account=$selected_account OR receivables_account=$selected_account OR payment_discount_account=$selected_account"; - $result = db_query($sql,"Couldn't test for existing tax GL codes"); + $result = db_query($sql,"Couldn't test for existing cust branch GL codes"); $myrow = db_fetch_row($result); if ($myrow[0] > 0) @@ -155,9 +155,9 @@ function can_delete($selected_account) $sql= "SELECT COUNT(*) FROM ".TB_PREF."suppliers WHERE purchase_account=$selected_account - payment_discount_account=$selected_account + OR payment_discount_account=$selected_account OR payable_account=$selected_account"; - $result = db_query($sql,"Couldn't test for existing tax GL codes"); + $result = db_query($sql,"Couldn't test for existing suppliers GL codes"); $myrow = db_fetch_row($result); if ($myrow[0] > 0) -- 2.30.2