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?



On 26 Jul 2012, at 12:41, Jenny Blunt wrote:

How do I go about comparing two attributes from an update request?

I have the following in my default conf. file:

update request {
       SQL-Location := "%{sql: SELECT xxx}"
 }
      
update request {
       SQL-Location-Id := "%{sql: SELECT yyy }"
}

if (SQL-Location != SQL-Location-Id ) {
reject
}

And my debug log shows:

Info: Failed parsing "SQL-Location-Id": Unknown value SQL-Location-Id for attribute SQL-Location


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