<div dir="ltr">no, it's not for SELECT.<div>$dbr for SELECTs</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 6:16 PM, Fred Posner <span dir="ltr"><<a href="mailto:fred@palner.com" target="_blank">fred@palner.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 09:01 PM, Alex Balashov wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Does that work for SELECT queries? The documentation says it's only for<br>
INSERT, UPDATE and DELETE.<br>
<br>
<br>
</blockquote>
<br></div>
It did not during my test this afternoon.<br>
<br>
--fred<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="">
On 6 April 2014 02:14:24 CEST, Kelvin Chua <<a href="mailto:kelchy@gmail.com" target="_blank">kelchy@gmail.com</a>> wrote:<br>
<br>
dunno if this helps but i use $sqlrows(ca) to check whether there<br>
are rows returned<br>
<br>
Kelvin Chua<br>
<br>
<br>
On Sat, Apr 5, 2014 at 9:15 AM, Alex Balashov<br></div><div class="">
<<a href="mailto:abalashov@evaristesys.com" target="_blank">abalashov@evaristesys.com</a> <mailto:<a href="mailto:abalashov@evaristesys.com" target="_blank">abalashov@evaristesys.<u></u>com</a>>> wrote:<br>
<br>
On 04/05/2014 12:14 PM, Fred Posner wrote:<br>
<br>
> I don't think so. As I understood the documentation, at<br>
least, $dbr<br>
> doesn't get populated in this case; the rows just go<br>
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>
<br>
<br>
This does make me wonder if there is a "leak" of result handles<br>
here, since sql_result_free() is not possible, but presumably<br>
there's an internal result handle still getting allocated. Or<br>
maybe that was for the memory allocated to the $dbr(...) data<br>
only and independent of the underlying DB API.<br>
<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></div>
Tel: <a href="tel:%2B1-678-954-0670" value="+16789540670" target="_blank">+1-678-954-0670</a> <tel:%2B1-678-954-0670><div class=""><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>
______________________________<u></u>___________________<div class=""><br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users<br>
mailing list<br></div>
<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a> <mailto:<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-<u></u>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> <<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>
<br>
<br>
------------------------------<u></u>------------------------------<u></u>------------<div class=""><br>
<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>
<br>
<br>
--<br>
Sent from my mobile, and thus lacking in the refinement one might expect<br>
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: <a href="tel:%2B1-678-954-0671" value="+16789540671" target="_blank">+1-678-954-0671</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>
<br></div><div class="">
______________________________<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>
<br>
</div></blockquote><div class="HOEnZb"><div class="h5">
<br>
______________________________<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>