date bugs in add and update
authorJoe Hunt <joe.hunt.consulting@gmail.com>
Fri, 16 Oct 2009 08:11:37 +0000 (08:11 +0000)
committerJoe Hunt <joe.hunt.consulting@gmail.com>
Fri, 16 Oct 2009 08:11:37 +0000 (08:11 +0000)
dimensions/includes/dimensions_db.inc

index 9b08207ea20f3485fa1e9c4dd80101c88c318a7f..756ff255a7ec737dfb965ac194e42245e6869402 100644 (file)
@@ -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");