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"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</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">
Hello,<br>
<br>
sql_xquery() does not set $dbr(...), but $xavp(...). And I don'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->nrows & res->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"><<a href="mailto:brandon@cryy.com" target="_blank">brandon@cryy.com</a>></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=>rows). I am receiving rows
back that are being populated into xavp via sql_xquery.
However the result of $dbr(key=>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>