fixed => Re: questions regarding sql xlat

2009-04-20 Thread Uwe Kastens
Hi list, >> >> So this should work? ATM I am nearly sure that this could never work, >> since the 1st query will deliver the string, that rlm_sql should expand >> with another query. >> >> But it would be great if it will work :-) > > rlm_sql does recursive xlat, all xlat expansions in the SQL qu

Re: questions regarding sql xlat

2009-04-20 Thread Arran Cudbard-Bell
On 20/4/09 09:34, Uwe Kastens wrote: Arran, If I try to use sql xlat I will get the answer: Error: rlm_sql: Failed to create the pair: Unknown value %{sql:SELECT disctime.time FROM `disctime` WHERE disctime.user = %{User-Name}} for attribute Session-Timeout Sun Apr 19 20:11:03 2009 : Error:

Re: questions regarding sql xlat

2009-04-20 Thread Uwe Kastens
Arran, >> If I try to use sql xlat I will get the answer: >> Error: rlm_sql: Failed to create the pair: Unknown value %{sql:SELECT >> disctime.time FROM `disctime` WHERE disctime.user = %{User-Name}} for >> attribute Session-Timeout >> Sun Apr 19 20:11:03 2009 : Error: rlm_sql (sql): Error gett

Re: questions regarding sql xlat

2009-04-20 Thread Arran Cudbard-Bell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Uwe Kastens wrote: > Hello list, > > I am trying to use some internal database function to calculate the > Session-Timeout. > > If I set the value for Session-Timeout to a integer like 123, its > correctly delivered as answer to my request. > > If I tr

questions regarding sql xlat

2009-04-19 Thread Uwe Kastens
Hello list, I am trying to use some internal database function to calculate the Session-Timeout. If I set the value for Session-Timeout to a integer like 123, its correctly delivered as answer to my request. If I try to use sql xlat I will get the answer: Error: rlm_sql: Failed to create the pai