questions regarding sql xlat

[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 getting data from
>> database
> 
>> I tried several different things: Use a select statement to query the
>> integer directly. I ends up in the same error. I am using:
> 
> *sigh* single quotation marks around %{User-Name}, it's still a string
> remember....

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 :-)

BR

Uwe
-- 

kiste lat: 54.322684, lon: 10.13586