From: Joe Hunt Date: Sun, 21 Sep 2008 09:12:44 +0000 (+0000) Subject: *** empty log message *** X-Git-Tag: 2.3-final~1448 X-Git-Url: https://delta.frontaccounting.com/gitweb/?p=fa-stable.git;a=commitdiff_plain;h=fccdc9f6007aada8f1c0b4d65ba8091f48d7131b *** empty log message *** --- diff --git a/dimensions/inquiry/search_dimensions.php b/dimensions/inquiry/search_dimensions.php index 4dd105dc..14ce24ab 100644 --- a/dimensions/inquiry/search_dimensions.php +++ b/dimensions/inquiry/search_dimensions.php @@ -137,7 +137,7 @@ while ($myrow = db_fetch($result)) $sql = "SELECT SUM(amount) FROM ".TB_PREF."gl_trans WHERE tran_date >= '" . date2sql($_POST['FromDate']) . "' AND tran_date <= '" . date2sql($_POST['ToDate']) . "' AND (dimension_id = " . - $myrow['id']." OR dimension2_id = " .$myrow['id']); + $myrow['id']." OR dimension2_id = " .$myrow['id'].")"; $res = db_query($sql, "Transactions could not be calculated"); $row = db_fetch_row($res);