X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=gl%2Fincludes%2Fdb%2Fgl_db_trans.inc;h=feb17f09baa3838bfe80a3ebc01b395ea894cce4;hb=2aea99756a8c19766f0f9dfee56b27f7c1994f37;hp=4e907726bdf56ef65c8cd4c05964395f7d8d77d6;hpb=6bcd87642330092910f5d6977845a76ac59350ac;p=fa-stable.git

diff --git a/gl/includes/db/gl_db_trans.inc b/gl/includes/db/gl_db_trans.inc
index 4e907726..feb17f09 100644
--- a/gl/includes/db/gl_db_trans.inc
+++ b/gl/includes/db/gl_db_trans.inc
@@ -148,7 +148,7 @@ function get_gl_transactions($from_date, $to_date, $trans_no=0,
         AND gl.amount <> 0"; 
 
     if ($trans_no > 0)
-        $sql .= " AND gl.type_no LIKE ".db_escape('%'.$trans_no);;
+        $sql .= " AND gl.type_no LIKE ".db_escape('%'.$trans_no);
 
     if ($account != null)
         $sql .= " AND gl.account = ".db_escape($account);
@@ -468,8 +468,10 @@ function add_trans_tax_details($trans_type, $trans_no, $tax_id, $rate, $included
 		(trans_type, trans_no, tran_date, tax_type_id, rate, ex_rate,
 			included_in_price, net_amount, amount, memo, reg_type)
 		VALUES (".db_escape($trans_type)."," . db_escape($trans_no).",'"
-				.date2sql($tran_date)."',".db_escape($tax_id).","
-				.db_escape($rate).",".db_escape($ex_rate).",".($included ? 1:0).","
+				.date2sql($tran_date)."',"
+				.(int)($tax_id).","
+				.(float)($rate).","
+				.(float)($ex_rate).",".($included ? 1:0).","
 				.db_escape($net_amount).","
 				.db_escape($amount).",".db_escape($memo).",".db_escape($reg_type, true).")";