diff options
-rw-r--r-- | modules-available/statistics/inc/hardwarequery.inc.php | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/modules-available/statistics/inc/hardwarequery.inc.php b/modules-available/statistics/inc/hardwarequery.inc.php index 2cded089..24b27190 100644 --- a/modules-available/statistics/inc/hardwarequery.inc.php +++ b/modules-available/statistics/inc/hardwarequery.inc.php @@ -79,15 +79,16 @@ class HardwareQuery $this->joins[$prop] = "INNER JOIN $table $tid ON ($srcTable.$column = $tid.$column AND $tid.prop = :$pid)"; $this->args[$pid] = $prop; + $this->columns[$prop] = "$tid.`value` AS `$prop`"; } $jtid = $this->id(); $cond = ''; if (!empty($condColumn)) { $vid = $this->id(); if (is_array($condVal)) { - $cond = " AND $jtid.`$condColumn` IN (:vid)"; + $cond = " AND $jtid.`$condColumn` IN (:$vid)"; } else { - $cond = " AND $jtid.`$condColumn` = :vid"; + $cond = " AND $jtid.`$condColumn` = :$vid"; } $this->args[$vid] = $condVal; } |