Re: Query help

2012-10-14 Thread Fajar A. Nugraha
On Mon, Oct 15, 2012 at 7:35 AM, Fajar A. Nugraha wrote: > If yes, it should be MUCH quicker to simply do the comparison INSIDE > the sql statement. Something like (untested, should work for mysql): > > if ("%{sql: ( (SELECT radgroupcheck.value FROM radusergroup Inner Join > radgroupcheck ON radus

Re: Query help

2012-10-14 Thread Fajar A. Nugraha
On Fri, Oct 12, 2012 at 3:16 PM, Jonathan Bastin wrote: > Issue with doing it that way is you would get decimal values returned which > freeradius can't deal with. > > I am posting a bounty of $200 Good to hear that. Hopefuly someone will be able to help you. > to someone that writes this in Per

Re: Query help

2012-10-14 Thread Arran Cudbard-Bell
On 12 Oct 2012, at 09:16, Jonathan Bastin wrote: > Issue with doing it that way is you would get decimal values returned which > freeradius can't deal with. > So use round()... http://www.w3schools.com/sql/sql_func_round.asp -Arran - List info/subscribe/unsubscribe? See http://www.freeradiu