[OpenSIPS-Users] AVP_DB_Querry transformation question

[Travis Manson-Drake]

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



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20160125/49707d82/attachment.htm>