summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorivan <ivan>2002-11-05 23:34:11 +0000
committerivan <ivan>2002-11-05 23:34:11 +0000
commitd32ae4e36b14a3418979856e3ee3f662c5290d65 (patch)
tree369263d8b71b84e0aac0de53dbec9c8f8f797557
parent548a47b0ec1040320e56f17cfac71f716785cb95 (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 e0d582b51..7516be599 100644
--- a/FS/FS/cust_svc.pm
+++ b/FS/FS/cust_svc.pm
@@ -477,14 +477,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];