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