Daniel,<div><br></div><div>   Indeed this seems to be the case at least in 3.2 - I guess I assumed they would export the same pseudo variable access.</div><div><br></div><div>Is there any reason to use sql_xquery vs sql_query?</div>
<div><br></div><div>Looking through the source it seems they both now handle the same or similar data types?</div><div><br></div><div>Sincerely,</div><div>Brandon Armstead</div><div class="gmail_extra"><br><br><div class="gmail_quote">
On Mon, Nov 26, 2012 at 12:21 PM, Daniel-Constantin Mierla <span dir="ltr">&lt;<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>&gt;</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">
    Hello,<br>
    <br>
    sql_xquery() does not set $dbr(...), but $xavp(...). And I don&#39;t
    think it sets any xavp with the number of rows and number of
    columns. The readme should have some examples, IIRC (not being the
    developer of this function).<br>
    <br>
    Cheers,<br>
    Daniel<div><div class="h5"><br>
    <br>
    <div>On 11/26/12 9:16 PM, Brandon Armstead
      wrote:<br>
    </div>
    </div></div><blockquote type="cite"><div><div class="h5">Hello,
      <div><br>
      </div>
      <div>   Almost forgot to add - this is on Kamailio 3.2 ---
        checking master branch to see if there is any changes, but it
        does look like in 3.2 res-&gt;nrows &amp; res-&gt;ncols is not
        being set.</div>
      <div class="gmail_extra">
        <br>
        <br>
        <div class="gmail_quote">On Mon, Nov 26, 2012 at 11:50 AM,
          Brandon Armstead <span dir="ltr">&lt;<a href="mailto:brandon@cryy.com" target="_blank">brandon@cryy.com</a>&gt;</span> wrote:<br>
          <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
            Hello,
            <div><br>
            </div>
            <div>   There appears to be an issue with the exported
              pseudo variable $dbr(key=&gt;rows).  I am receiving rows
              back that are being populated into xavp via sql_xquery.
               However the result of $dbr(key=&gt;rows) is zero.</div>
            <div><br>
            </div>
            <div>Perhaps I am doing something wrong or sql_xquery does
              not populate the $dbr pseudo variable?</div>
            <div><br>
            </div>
            <div>Thanks in advance.</div>
            <div><br>
            </div>
            <div>Sincerely,</div>
            <div>Brandon Armstead</div>
          </blockquote>
        </div>
        <br>
      </div>
      <br>
      <fieldset></fieldset>
      <br>
      </div></div><pre>_______________________________________________
sr-dev mailing list
<a href="mailto:sr-dev@lists.sip-router.org" target="_blank">sr-dev@lists.sip-router.org</a>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev</a><span class="HOEnZb"><font color="#888888">
</font></span></pre><span class="HOEnZb"><font color="#888888">
    </font></span></blockquote><span class="HOEnZb"><font color="#888888">
    <br>
    <pre cols="72">-- 
Daniel-Constantin Mierla - <a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a href="http://twitter.com/#!/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a></pre>
  </font></span></div>

</blockquote></div><br></div>