diff options
author | ivan <ivan> | 2002-11-05 23:34:13 +0000 |
---|---|---|
committer | ivan <ivan> | 2002-11-05 23:34:13 +0000 |
commit | 32f89323fd86acd0370081628f88a0c9db1cf034 (patch) | |
tree | c36695ccfa81bcf7640bfd61ee4860cd5c29542c | |
parent | 9ba2416211d9eba2914f524d07987b96d21f354b (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 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]; |