summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorivan <ivan>2002-11-05 23:34:13 +0000
committerivan <ivan>2002-11-05 23:34:13 +0000
commit32f89323fd86acd0370081628f88a0c9db1cf034 (patch)
treec36695ccfa81bcf7640bfd61ee4860cd5c29542c
parent9ba2416211d9eba2914f524d07987b96d21f354b (diff)
can't use placeholders in SELECT SUM(?)
-rw-r--r--FS/FS/cust_svc.pm4
1 files changed, 2 insertions, 2 deletions
diff --git a/FS/FS/cust_svc.pm b/FS/FS/cust_svc.pm
index 223331932..67e0709ce 100644
--- a/FS/FS/cust_svc.pm
+++ b/FS/FS/cust_svc.pm
@@ -481,14 +481,14 @@ sub attribute_since_sqlradacct {
$str2time = 'extract(epoch from ';
}
- my $sth = $dbh->prepare("SELECT SUM(?)
+ my $sth = $dbh->prepare("SELECT SUM($attrib)
FROM radacct
WHERE UserName = ?
AND $str2time AcctStopTime ) >= ?
AND $str2time AcctStopTime ) < ?
AND AcctStopTime IS NOT NULL"
) or die $dbh->errstr;
- $sth->execute($attrib, $username, $start, $end) or die $sth->errstr;
+ $sth->execute($username, $start, $end) or die $sth->errstr;
$sum += $sth->fetchrow_arrayref->[0];