From 57ab7b19733486db1572c646c4ff0a58c260ddd2 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Fri, 20 Apr 2007 07:17:58 +0000 Subject: [PATCH] Fixed bug no 1703891 Reserved MySQL words used as column names Fixed bug no 1703895 Account numbers are varchars, need quotes --- taxes/db/tax_types_db.inc | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) diff --git a/taxes/db/tax_types_db.inc b/taxes/db/tax_types_db.inc index ce4495bf..c5408af0 100644 --- a/taxes/db/tax_types_db.inc +++ b/taxes/db/tax_types_db.inc @@ -2,8 +2,8 @@ function add_tax_type($name, $sales_gl_code, $purchasing_gl_code, $rate, $out) { - $sql = "INSERT INTO ".TB_PREF."tax_types (name, sales_gl_code, purchasing_gl_code, rate, out) - VALUES ('$name', $sales_gl_code, $purchasing_gl_code, $rate, $out)"; + $sql = "INSERT INTO ".TB_PREF."tax_types (name, sales_gl_code, purchasing_gl_code, rate, `out`) + VALUES ('$name', '$sales_gl_code', '$purchasing_gl_code', $rate, $out)"; db_query($sql, "could not add tax type"); } @@ -11,10 +11,10 @@ function add_tax_type($name, $sales_gl_code, $purchasing_gl_code, $rate, $out) function update_tax_type($type_id, $name, $sales_gl_code, $purchasing_gl_code, $rate, $out) { $sql = "UPDATE ".TB_PREF."tax_types SET name='$name', - sales_gl_code=$sales_gl_code, - purchasing_gl_code=$purchasing_gl_code, + sales_gl_code='$sales_gl_code', + purchasing_gl_code='$purchasing_gl_code', rate=$rate, - out=$out + `out`=$out WHERE id=$type_id"; db_query($sql, "could not update tax type"); -- 2.30.2