More efficient programming of the unlang language

[Marijn van Gool]

> Pretty much what you've written? This is all in the unlang man page.

I’ve checked both the Unlang documentation online as well as man unlang page.
Both did not give me the correct information to use, hence I’m asking this question. I was quite stuck.

> Use a temporary attribute, something like
> 
> update control {
> 	&Tmp-String-1 := "%{sql:SELECT username .....}"
> }        
> 
> if (&control:Tmp-String-1) {
> 	update request {
>        	&User-Name := &control:Tmp-String-1
> 	}        
> }
> 
> I'd update the things that use the User-Name attribute, though, rather
> than changing the attribute itself.

Thanks a lot. It’s pretty much what I’ve written, I agree.
I was just missing the right syntax.

Met vriendelijke groet \ With kind regards,

Marijn van Gool
NOC Network Engineer
noc at comsave.com <mailto:noc at comave.com> 

+31 88 999 5555
marijn.vangool at comsave.com <mailto:marijn.vangool at comsave.com> 
www.comsave.nl <http://www.comsave.nl/> 






> On 23 Apr 2018, at 16:13, Matthew Newton <mcn at freeradius.org> wrote:
> 
> On Mon, 2018-04-23 at 15:56 +0200, Marijn van Gool wrote:
>> 
>> if ("%{sql:SELECT username FROM radcheck WHERE username LIKE
>> '%{string:&ADSL-Agent-Remote-Id}@%%' LIMIT 1}" != "") {
>> 	update request {
>>        	User-Name := "%{sql:SELECT username FROM radcheck
>> WHERE username LIKE '%{string:&ADSL-Agent-Remote-Id}@%%' LIMIT 1}"
>> 	}        
>> }
>> 
>> Basically what I’m trying to do is to check if the query in question
>> returns the username and to use this username in a self created
>> variable later on.
>> Something like this:
>> 
>> username-var = SELECT query;
>> 
>> if (username-var != “”) {
>> 	update-request {
>> 		User-Name := username-var
>> 	}
>> }
>> 
>> How would I achieve this? What is the syntax that can be used here?
> 
> Pretty much what you've written? This is all in the unlang man page.
> 
> Use a temporary attribute, something like
> 
> update control {
> 	&Tmp-String-1 := "%{sql:SELECT username .....}"
> }        
> 
> if (&control:Tmp-String-1) {
> 	update request {
>        	&User-Name := &control:Tmp-String-1
> 	}        
> }
> 
> I'd update the things that use the User-Name attribute, though, rather
> than changing the attribute itself.
> 
> -- 
> Matthew
> 
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html