Request Items, Config/control Items; rlm_sql

[Phil Mayers]

Michael Bryant wrote:
>> authorize {
>>    update request {
>>      Tmp-String=0 = "%{sql:select ...}"
>>    }
>>    sql
>> }
> 
> Unfortunately that's no use, as I understand it, redundant blocks aren't
> supported in xlat?

Ah, so your "sql" module is actually:

instantiate {
   sql {
     sql1
     sql2
   }
}

Your original message didn't say that.

You can't do this entirely in FreeRadius' built-in logic I believe. You 
could write a stored procedure to do the logic on the server-side (if 
your database supports it) or run the logic inside a perl/python script.

What are you trying to accomplish? Perhaps there are alternatives.

In some respects the sql module is a bit limited; it would be nice for 
some use-cased if FR could pull back rowsets (i.e. >1 row, >1 column) 
into some kind of unlang variable which you could then loop over, but 
then unlang would be more a... lang ;o)