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