<html><head></head><body>Does that work for SELECT queries? The documentation says it's only for INSERT, UPDATE and DELETE. <br>
<br><br><div class="gmail_quote">On 6 April 2014 02:14:24 CEST, Kelvin Chua <kelchy@gmail.com> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div dir="ltr"><div>dunno if this helps but i use $sqlrows(ca) to check whether there are rows returned</div></div><div class="gmail_extra"><br clear="all" /><div>Kelvin Chua</div>
<br /><br /><div class="gmail_quote">On Sat, Apr 5, 2014 at 9:15 AM, Alex Balashov <span dir="ltr"><<a href="mailto:abalashov@evaristesys.com" target="_blank">abalashov@evaristesys.com</a>></span> wrote:<br /><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="">On 04/05/2014 12:14 PM, Fred Posner wrote:<br />
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
> I don't think so. As I understood the documentation, at least, $dbr<br />
> doesn't get populated in this case; the rows just go straight to an<br />
> xavp list. I suppose I should verify that.<br />
><br />
<br />
Looks like you're right.<br />
<br />
Tested various methods.<br />
</blockquote>
<br /></div>
This does make me wonder if there is a "leak" of result handles here, since sql_result_free() is not possible, but presumably there's an internal result handle still getting allocated. Or maybe that was for the memory allocated to the $dbr(...) data only and independent of the underlying DB API.<div class="im HOEnZb">
<br />
<br />
-- <br />
Alex Balashov - Principal<br />
Evariste Systems LLC<br />
235 E Ponce de Leon Ave<br />
Suite 106<br />
Decatur, GA 30030<br />
United States<br />
Tel: <a href="tel:%2B1-678-954-0670" value="+16789540670" target="_blank">+1-678-954-0670</a><br />
Web: <a href="http://www.evaristesys.com/" target="_blank">http://www.evaristesys.com/</a>, <a href="http://www.alexbalashov.com/" target="_blank">http://www.alexbalashov.com/</a><br />
<br /></div><div class="HOEnZb"><div class="h5">
______________________________<u></u>_________________<br />
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br />
<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a><br />
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/<u></u>cgi-bin/mailman/listinfo/sr-<u></u>users</a><br />
</div></div></blockquote></div><br /></div>
<p style="margin-top: 2.5em; margin-bottom: 1em; border-bottom: 1px solid #000"></p><pre class="k9mail"><hr /><br />SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br />sr-users@lists.sip-router.org<br /><a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br /></pre></blockquote></div><br>
--<br>
Sent from my mobile, and thus lacking in the refinement one might expect from a fully fledged keyboard. <br>
<br>
Alex Balashov - Principal <br>
Evariste Systems LLC<br>
235 E Ponce de Leon Ave<br>
Suite 106<br>
Decatur, GA 30030<br>
United States<br>
Tel: +1-678-954-0671<br>
Web: <a href="http://www.evaristesys.com">http://www.evaristesys.com</a>/, <a href="http://www.alexbalashov.com">http://www.alexbalashov.com</a></body></html>