<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>