<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tt>Travis,<br>
<br>
The documentation on formating the variables is available under:<br>
<a class="moz-txt-link-freetext" href="http://www.opensips.org/Documentation/Script-CoreVar-2-1">http://www.opensips.org/Documentation/Script-CoreVar-2-1</a><br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<div class="moz-cite-prefix">On 26.01.2016 00:16, Travis
Manson-Drake wrote:<br>
</div>
<blockquote
cite="mid:CY1PR0601MB1611E257D4AF712D89F61120CDC70@CY1PR0601MB1611.namprd06.prod.outlook.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Segoe UI";
panose-1:2 11 5 2 4 2 4 2 2 3;}
@font-face
{font-family:"Segoe UI Semibold";
panose-1:2 11 7 2 4 2 4 2 2 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.apple-converted-space
{mso-style-name:apple-converted-space;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">That
did it!<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Thank
you!<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif">
<a class="moz-txt-link-abbreviated" href="mailto:users-bounces@lists.opensips.org">users-bounces@lists.opensips.org</a>
[<a class="moz-txt-link-freetext" href="mailto:users-bounces@lists.opensips.org">mailto:users-bounces@lists.opensips.org</a>]
<b>On Behalf Of </b><a class="moz-txt-link-abbreviated" href="mailto:jarrod@unixc.org">jarrod@unixc.org</a><br>
<b>Sent:</b> Monday, January 25, 2016 3:11 PM<br>
<b>To:</b> OpenSIPS users mailling list
<a class="moz-txt-link-rfc2396E" href="mailto:users@lists.opensips.org"><users@lists.opensips.org></a><br>
<b>Subject:</b> Re: [OpenSIPS-Users] AVP_DB_Querry
transformation question<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">try $(fU{s.escape.common})<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal">On Jan 25, 2016, at 4:09 PM, Travis
Manson-Drake <<a moz-do-not-send="true"
href="mailto:travism@simplybits.com">travism@simplybits.com</a>>
wrote:<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif">Hello
everyone,<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif">I
can’t seem to find any documentation on how to
format my Query while using the {s.escape.common}
transformation.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif">I
tried setting it up as follows:<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif">select
MAC FROM `phone_registrations` where auth_userid =
'$fU{s.escape.common}'))", "$avp(PBX)")<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif">however
the query just returns the value PV $fU with
{s.escape.common} in the return, for example
7117test{s.escape.common}<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif">where
should I apply the transformation? Can someone give
me an example?<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif">Thank
you for your time.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <o:p></o:p></span></p>
</div>
<table class="MsoNormalTable" style="width:3.25in"
border="0" cellpadding="0" cellspacing="3" width="312">
<tbody>
<tr>
<td style="width:231.0pt;padding:0in 0in 0in 0in"
valign="top" width="308">
<div>
<p class="MsoNormal"
style="mso-line-height-alt:11.55pt"><span
style="font-size:13.0pt;font-family:"Segoe
UI",sans-serif;color:#1884C6;letter-spacing:-.75pt">Travis
Manson-Drake<br>
</span><span
style="font-size:13.0pt;font-family:"Segoe
UI",sans-serif;color:#F79321;letter-spacing:-.75pt">Voice Systems
Analyst</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p></o:p></span></p>
</div>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span
style="font-size:9.0pt;font-family:"Helvetica",sans-serif;display:none"><o:p> </o:p></span></p>
<table class="MsoNormalTable"
style="width:3.25in;border:none;border-top:solid
windowtext 2.25pt" border="1" cellpadding="0"
cellspacing="3" width="312">
<tbody>
<tr style="height:1.35pt">
<td style="width:231.0pt;border:none;padding:.75pt
.75pt .75pt .75pt;height:1.35pt" width="308">
<div>
<p class="MsoNormal"
style="mso-line-height-alt:11.55pt"><span
style="font-size:13.0pt;font-family:"Segoe
UI",sans-serif;color:#1884C6;letter-spacing:-.75pt">Simply Bits,
LLC<br>
</span><span
style="font-size:10.0pt;font-family:"Segoe
UI",sans-serif;letter-spacing:1.0pt">T:<span
class="apple-converted-space"><span
style="color:#1F497D"> </span></span><span
style="color:#1B84C7">520.545.0311 <span
class="apple-converted-space"> </span></span><span
style="color:#2D2D2D">F:</span><span
class="apple-converted-space"><span
style="color:#1F497D"> </span></span><span
style="color:#1B84C7">520.545.7252<br>
</span>E:<span class="apple-converted-space"><span
style="color:#1F497D"> </span></span></span><a
moz-do-not-send="true"
href="mailto:email@simplybits.com"><span
style="font-size:10.0pt;font-family:"Segoe
UI",sans-serif;color:#0563C1;letter-spacing:1.0pt"><a class="moz-txt-link-abbreviated" href="mailto:email@simplybits.com">email@simplybits.com</a></span></a><span
style="font-size:10.0pt;font-family:"Segoe
UI",sans-serif;color:#1B84C7;letter-spacing:1.0pt"> <br>
</span><span
style="font-size:10.0pt;font-family:"Segoe
UI",sans-serif">5225 N. Sabino Canyon
Road<br>
Tucson, AZ 85750<br>
</span><span
style="font-size:10.0pt;font-family:"Segoe
UI Semibold",sans-serif">Support
Hotline: 520.545.0333</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p></o:p></span></p>
</div>
</td>
</tr>
</tbody>
</table>
<div>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span
style="font-size:9.0pt;font-family:"Helvetica",sans-serif">_______________________________________________<br>
Users mailing list<br>
</span><a moz-do-not-send="true"
href="mailto:Users@lists.opensips.org"><span
style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:#954F72">Users@lists.opensips.org</span></a><span
style="font-size:9.0pt;font-family:"Helvetica",sans-serif"><br>
</span><a moz-do-not-send="true"
href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users"><span
style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:#954F72">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</span></a><o:p></o:p></p>
</div>
</blockquote>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>