Query help

[Phil Mayers]

On 10/10/12 14:23, Jonathan Bastin wrote:
> I have been looking at this further am I am having trouble finding the answer. Is anyone able to point me into the right direction.

You might find it a bit easier to debug if you perform the two SQL 
queries (for the quota, and the current limit) separately, then compare 
the values. For example:

update control {
   Tmp-Integer-0 := "%{sql:select quota_limit ...}"
   Tmp-Integer-1 := "%{sql:select sum(...) from radacct where ...}"
}
if (control:Tmp-Integer-0 < "%{control:Tmp-Integer-1}") {
   reject
}

This will at least make it more obvious what is going on. To be frank, I 
can't really understand what's going on in that debug.