Hello, In the module IP POOL, I'm trying to use the "%" SQL chars. allocate-find = "SELECT ip_address FROM radippool WHERE (pool_name like '%{reply:Pool-Suffix}*\%' and pool_name not like '\%STAT\%')..... The issue is that the module expand the %S as a variable. (Time) What can I do to avoid that ? Thanks
On Tue, 2019-04-30 at 15:23 +0000, Nicolas Breuer wrote:
In the module IP POOL, I'm trying to use the "%" SQL chars.
allocate-find = "SELECT ip_address FROM radippool WHERE (pool_name like '%{reply:Pool-Suffix}*\%' and pool_name not like '\%STAT\%').....
The issue is that the module expand the %S as a variable. (Time) What can I do to avoid that ?
"%%" expands to "%". -- Matthew
On 30/04/2019 16:31, Matthew Newton wrote:
On Tue, 2019-04-30 at 15:23 +0000, Nicolas Breuer wrote:
In the module IP POOL, I'm trying to use the "%" SQL chars. The issue is that the module expand the %S as a variable. (Time) What can I do to avoid that ?
"%%" expands to "%".
So for example, in this: WHERE (maclist.value LIKE '%%%{request:Calling-Station-Id}%%' the outer "%%" gets expanded to a single "%" (sql wildcard) and then the other one is used to expand the request value.
participants (3)
-
Dom Latter -
Matthew Newton -
Nicolas Breuer