unlang question

[Alan DeKok]

Norbert Wegener wrote:
> With unlang I achive the following: Check, whether a special VLAN exists
> on a switch and if so, assign it.
...
> To reduce sql queries I want to avoid the second.
> Can I store the result of the first query and use the value to assign
> Tunnel-Private-Group-ID?

  Yes.  Intermediate variables are possible.

  update control {
	Tmp-String-0 = "%{sqlquery:SELECT value from ...
  }

  if (control:Tmp-String-0 != "") {
	update reply {
		Tunnel-Private-Group-ID = "%{Tmp-String-0}"
		...
	}
  }

  Alan DeKok.