[OpenSIPS-Users] AVP_DB_Querry transformation question

[jarrod at unixc.org]

try $(fU{s.escape.common})

> On Jan 25, 2016, at 4:09 PM, Travis Manson-Drake <travism at simplybits.com> wrote:
> 
> Hello everyone,
>  
> I can’t seem to find any documentation on how to format my Query while using the {s.escape.common} transformation.
>  
> I tried setting it up as follows:
>  
>  
> select MAC FROM `phone_registrations` where auth_userid = '$fU{s.escape.common}'))", "$avp(PBX)")
>  
> however the query just returns the value PV $fU with {s.escape.common} in the return, for example 7117test{s.escape.common}
>  
> where should I apply the transformation? Can someone give me an example?
>  
> Thank you for your time.
>  
> Travis Manson-Drake
> Voice Systems Analyst
> Simply Bits, LLC
> T: 520.545.0311  F: 520.545.7252
> E: email at simplybits.com <mailto:email at simplybits.com> 
> 5225 N. Sabino Canyon Road
> Tucson, AZ 85750
> Support Hotline: 520.545.0333
>  
>  
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org <mailto:Users at lists.opensips.org>
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users <http://lists.opensips.org/cgi-bin/mailman/listinfo/users>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20160125/34bcb5c4/attachment-0001.htm>