Blank value of temporary variable in Unlang

[Mrinal K]

I am implementing a setup where we return expiry date value as per a user's
settings. For this I have added a column in radcheck table called
ExpiryDate.

I have added following in authorize section in sites-available/defaults

update control{
                My-Local-Int-1 := "%{sql: select id from radcheck where
username='%{User-Name}' order by id desc limit 1}"
        }

        update reply{
                WISPr-Session-Terminate-Time = "%{sql: select ExpiryDate
from radcheck where id = '%{My-Local-Int-1}'}"
        }



The username I am testing with has ExpiryDate value in radcheck table,
however mysql query log shows me blank value for  '%{My-Local-Int-1}' for
query in update reply {.. } section.

Please suggest what I am doing wrong. My-Local-Int-1 has been defined in
dictionary as integer.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20141106/bcc1fc09/attachment.html>