Re: Run time variable in sql

26 Mar 2018

      On Mar 26, 2018, at 8:05 AM, rob-ml@mailbox.org wrote:
...
now tested, no matter which operator, always with the same result.
Receive:
(3)   Actual-Data-Rate-Upstream = 41999
(3)   Actual-Data-Rate-Downstream = 109066
Processing in radiusd -X debug:
(3) sql: EXPAND `%{request:Actual-Data-Rate-Upstream}00`
(3) sql:    --> `4199900`
(3) sql: EXPAND `%{request:Actual-Data-Rate-Downstream}00`
(3) sql:    --> `10906600`
Ah... a careful reading of the debug output helps here.

  A back-tick quoted string calls a *program*.  e.g. `/bin/echo foo`

  You probably want to use normal double quotes.

  Alan DeKok.