Thanks, my mistake - copied from wrong place. On 27 Jul 2012, at 14:27, Alan DeKok wrote:
Jenny Blunt wrote:
On a similar note, If I wanted to use the first result in the second update request, how can I go about that?
I've tried the following, but I get a blank value for SQL-Location-Id
update request { SQL-Location := "%{sql: SELECT xxx}" }
update request { SQL-Location-Id := "%{sql: SELECT * where XXX = '%{SQL-Location-Id}' }" }
Is this possible?
Of course. It works. There's no magic.
Read the debug log to see what's going on. And post the REAL configuration lines you're using. Re-typing them means typos && mistakes, which makes it impossible to help you.
i.e. your second line updates SQL-Location-Id by referencing SQL-Location-Id. That looks wrong.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html