2 Dec
2008
2 Dec
'08
4:31 p.m.
#query = "SELECT SUM(OctetTotal) FROM thismonthsusage WHERE UsernameView='%{%k}'" }
..
As soon as a new month rolls over there are NO accounting entries for that user for that month, hence no record and freeradius denies user as he hasn't got any entries, any body know how I should modify the view to display all users even if they don't have an entry for current month, but rather display them with value 0 as apposed to not at all?
Your question belongs on the MySQL forum. Use if() function: SELECT IF(SUM(OctetTotal) IS NULL, 0, SUM(OctetTotal)) FROM ... Ivan Kalik Kalik Informatika ISP