[OpenSIPS-Users] AVP_DB_Querry transformation question

[Bogdan-Andrei Iancu]

Travis,

The documentation on formating the variables is available under:
     http://www.opensips.org/Documentation/Script-CoreVar-2-1

Regards,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com

On 26.01.2016 00:16, Travis Manson-Drake wrote:
>
> That did it!
>
> Thank you!
>
> *From:*users-bounces at lists.opensips.org 
> [mailto:users-bounces at lists.opensips.org] *On Behalf Of *jarrod at unixc.org
> *Sent:* Monday, January 25, 2016 3:11 PM
> *To:* OpenSIPS users mailling list <users at lists.opensips.org>
> *Subject:* Re: [OpenSIPS-Users] AVP_DB_Querry transformation question
>
> try $(fU{s.escape.common})
>
>     On Jan 25, 2016, at 4:09 PM, Travis Manson-Drake
>     <travism at simplybits.com <mailto: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
>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20160126/56068f5e/attachment.htm>