diff options
author | ivan <ivan> | 2002-11-05 23:34:11 +0000 |
---|---|---|
committer | ivan <ivan> | 2002-11-05 23:34:11 +0000 |
commit | d32ae4e36b14a3418979856e3ee3f662c5290d65 (patch) | |
tree | 369263d8b71b84e0aac0de53dbec9c8f8f797557 | |
parent | 548a47b0ec1040320e56f17cfac71f716785cb95 (diff) |
can't use placeholders in SELECT SUM(?)
-rw-r--r-- | FS/FS/cust_svc.pm | 4 |
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]; |