From: Joe Hunt <joe.hunt.consulting@gmail.com>
Date: Fri, 16 Oct 2009 08:11:37 +0000 (+0000)
Subject: date bugs in add and update
X-Git-Tag: 2.3-final~1127
X-Git-Url: https://delta.frontaccounting.com/gitweb/?p=fa-stable.git;a=commitdiff_plain;h=80b5959c7bd2d319d54cef0a234f9e0f6e830052

date bugs in add and update
---

diff --git a/dimensions/includes/dimensions_db.inc b/dimensions/includes/dimensions_db.inc
index 9b08207e..756ff255 100644
--- a/dimensions/includes/dimensions_db.inc
+++ b/dimensions/includes/dimensions_db.inc
@@ -18,7 +18,7 @@ function add_dimension($reference, $name, $type_, $date_, $due_date, $memo_)
 
 	$sql = "INSERT INTO ".TB_PREF."dimensions (reference, name, type_, date_, due_date)
 		VALUES (".db_escape($reference).", ".db_escape($name).", ".db_escape($type_)
-		.", ".db_escape($date_).", ".db_escape($due_date).")";
+		.", '$date', '$duedate')";
 	db_query($sql, "could not add dimension");
 
 	$id = db_insert_id();
@@ -41,8 +41,8 @@ function update_dimension($id, $name, $type_, $date_, $due_date, $memo_)
 
 	$sql = "UPDATE ".TB_PREF."dimensions SET name=".db_escape($name).",
 		type_ = ".db_escape($type_).",
-		date_=".db_escape($date_).",
-		due_date=".db_escape($due_date)."
+		date_='$date',
+		due_date='$duedate'
 		WHERE id = ".db_escape($id);
 
 	db_query($sql, "could not update dimension");