@Phil : that was it. I wrongly presumed that variables were directly accessible. Thank you. 

@Stefan: Thanks you Stefan for the response and clarity on how variables from lists are accessed.




On Thu, Nov 6, 2014 at 7:06 PM, Stefan Paetow <Stefan.Paetow@ja.net> wrote:
On 6 Nov 2014, at 13:08, Mrinal K <sinha.mrinal@gmail.com> wrote:
> I am getting value from the first query
>
> Heres my debug log, I have highlighted the required queries
[snip]
>         expand: %{sql: select ExpiryDate from radcheck where id = '%{My-Local-Int-1}'} ->

Use "%{sql: select ExpiryDate from radcheck where id = '%{control:My-Local-Int-1}'}"

You have to specify the attribute list that the attribute is from, otherwise it is assumed that the attribute is from the same list you are updating (in this case 'reply').

:-)

Stefan Paetow
Moonshot Industry & Research Liaison Coordinator

t: +44 (0)1235 822 125
gpg: 0x3FCE5142
xmpp: stefanp@jabber.dev.ja.net
skype: stefan.paetow.janet

Janet, the UK’s research and education network.

Janet(UK) is a trading name of Jisc Collections and Janet Limited, a
not-for-profit company which is registered in England under No. 2881024
and whose Registered Office is at Lumen House, Library Avenue,
Harwell Oxford, Didcot, Oxfordshire. OX11 0SG. VAT No. 614944238


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html