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)