<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tt>Hi Diptesh,<br>
<br>
Can you use the avp_db_load() function for your purpose ?<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 10/13/2017 08:05 AM, Dipteshkumar
Patel wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAD4_Da3GD6Y2yT3LiLwdFsgitfFLjuKLOW=HzTyYsJkS8=Wcgw@mail.gmail.com">
<div dir="ltr">hello sir,
<div><br>
</div>
<div>Thanks for your reply</div>
<div><br>
</div>
<div>Any other way to use prepaid statement in opensips</div>
<div class="gmail_extra"><br clear="all">
<div>
<div class="gmail_signature"
data-smartmail="gmail_signature">
<div dir="ltr"><b>Diptesh Patel</b>
<div>Jr. Software Developer </div>
<div>Ecosmob Technologies Ltd</div>
<div>Ahmedabad</div>
<div>Mo:<b>+919898962659</b></div>
</div>
</div>
</div>
<br>
<div class="gmail_quote">On Fri, Oct 13, 2017 at 1:35 AM,
Bogdan-Andrei Iancu <span dir="ltr"><<a
href="mailto:bogdan@opensips.org" target="_blank"
moz-do-not-send="true">bogdan@opensips.org</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> <tt>Hi Diptesh,<br>
<br>
The avp_db_query, as being a generic way to run raw
queries, has no support for prepared statements. <br>
<br>
Regards,<br>
</tt>
<pre class="m_5723190534232502819moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="m_5723190534232502819moz-txt-link-freetext" href="http://www.opensips-solutions.com" target="_blank" moz-do-not-send="true">http://www.opensips-solutions.<wbr>com</a>
</pre>
<div>
<div class="h5">
<div class="m_5723190534232502819moz-cite-prefix">On
09/29/2017 01:23 PM, Dipteshkumar Patel wrote:<br>
</div>
</div>
</div>
<blockquote type="cite">
<div>
<div class="h5">
<div dir="ltr">Dear Sir,
<div><br>
</div>
<div><br>
</div>
<div>I am using opensips 2.3.1 with multiple
queries(using avp_db_query) in opensips
configuration and i want to optimise it, and
yes i also use async for that but i need to
more optimisation.</div>
<div><br>
</div>
<div>how can we use prepared statement in
opensips script ?</div>
</div>
<br>
<fieldset
class="m_5723190534232502819mimeAttachmentHeader"></fieldset>
<br>
</div>
</div>
<pre>______________________________<wbr>_________________
Users mailing list
<a class="m_5723190534232502819moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org" target="_blank" moz-do-not-send="true">Users@lists.opensips.org</a>
<a class="m_5723190534232502819moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank" moz-do-not-send="true">http://lists.opensips.org/cgi-<wbr>bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</blockquote>
<br>
</body>
</html>