Comparing Two Attributes

Alan DeKok aland at deployingradius.com
Fri Jul 27 15:27:15 CEST 2012


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.


More information about the Freeradius-Users mailing list