Just another small question before i jump into testing. If output from sub-query is less than 32bit, I can easily store it in Tmp-Integer , But sometimes when the user data usage is null, the sub-query will output more than 32bit ex. 10GB Limit But user downloaded 0 Bytes.
In that condition it is impossible to store it in Tmp-Integer . So ultimately the Integer passed by xlat and the stored in Tmp-Integer will differ. Regards Suman Dash On Mon, Aug 8, 2011 at 7:45 PM, Arran Cudbard-Bell <a.cudba...@freeradius.org> wrote: > > On 8 Aug 2011, at 16:11, Suman Dash wrote: > >> So what you say is that i do all comparision within sql sub-query and >> whatever output i need to define if less than 32bit store it into an >> Integer and do Unlang control / reply updates ? >> >> Seems quite right .. Will try and get back with results. > > Exactly :) > > Feel free to post some samples if you get it working and i'll put them up on > the wiki. > > -Arran >> >> On Mon, Aug 8, 2011 at 3:31 PM, Arran Cudbard-Bell >> <a.cudba...@freeradius.org> wrote: >>> >>>> Unfortunately I am not much of a programmer . >>> >>> Ok... but you know SQL right? Which is why i'm suggesting to do the >>> comparison in the SQL database. >>> >>>> Therefore if you can put >>>> some examples / pointers based on my requirement, it will be a >>>> headstart for me . >>> >>> http://dev.mysql.com/doc/refman/5.0/en/comparisons-using-subqueries.html >>> >>> Use SELECT COUNT(*) for the outer query and then compare that value in >>> unlang. >>> >>> -Arran >>> >>> Arran Cudbard-Bell >>> a.cudba...@freeradius.org >>> >>> RADIUS - Half the complexity of Diameter >>> >>> >>> - >>> List info/subscribe/unsubscribe? See >>> http://www.freeradius.org/list/users.html >>> >> - >> List info/subscribe/unsubscribe? See >> http://www.freeradius.org/list/users.html >> > > Arran Cudbard-Bell > a.cudba...@freeradius.org > > RADIUS - Half the complexity of Diameter > > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html