[SR-Users] sql_xquery() and xavp checks

[Kelvin Chua]

no, it's not for SELECT.
$dbr for SELECTs

Kelvin Chua


On Sat, Apr 5, 2014 at 6:16 PM, Fred Posner <fred at palner.com> wrote:

> On 04/05/2014 09:01 PM, Alex Balashov wrote:
>
>> Does that work for SELECT queries? The documentation says it's only for
>> INSERT, UPDATE and DELETE.
>>
>>
>>
> It did not during my test this afternoon.
>
> --fred
>
>  On 6 April 2014 02:14:24 CEST, Kelvin Chua <kelchy at gmail.com> wrote:
>>
>>     dunno if this helps but i use $sqlrows(ca) to check whether there
>>     are rows returned
>>
>>     Kelvin Chua
>>
>>
>>     On Sat, Apr 5, 2014 at 9:15 AM, Alex Balashov
>>     <abalashov at evaristesys.com <mailto:abalashov at evaristesys.com>> wrote:
>>
>>         On 04/05/2014 12:14 PM, Fred Posner wrote:
>>
>>               > I don't think so. As I understood the documentation, at
>>             least, $dbr
>>               > doesn't get populated in this case; the rows just go
>>             straight to an
>>               > xavp list. I suppose I should verify that.
>>               >
>>
>>             Looks like you're right.
>>
>>             Tested various methods.
>>
>>
>>         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.
>>
>>
>>         --
>>         Alex Balashov - Principal
>>         Evariste Systems LLC
>>         235 E Ponce de Leon Ave
>>         Suite 106
>>         Decatur, GA 30030
>>         United States
>>         Tel: +1-678-954-0670 <tel:%2B1-678-954-0670>
>>
>>         Web: http://www.evaristesys.com/, http://www.alexbalashov.com/
>>
>>         _________________________________________________
>>
>>         SIP Express Router (SER) and Kamailio (OpenSER) - sr-users
>>         mailing list
>>         sr-users at lists.sip-router.org <mailto:sr-users at lists.sip-
>> router.org>
>>         http://lists.sip-router.org/__cgi-bin/mailman/listinfo/sr-__users<
>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users>
>>
>>
>>     ------------------------------------------------------------
>> ------------
>>
>>
>>     SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing
>> list
>>     sr-users at lists.sip-router.org
>>     http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>>
>>
>> --
>> Sent from my mobile, and thus lacking in the refinement one might expect
>> from a fully fledged keyboard.
>>
>> Alex Balashov - Principal
>> Evariste Systems LLC
>> 235 E Ponce de Leon Ave
>> Suite 106
>> Decatur, GA 30030
>> United States
>> Tel: +1-678-954-0671
>> Web: http://www.evaristesys.com/, http://www.alexbalashov.com
>>
>>
>> _______________________________________________
>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>> sr-users at lists.sip-router.org
>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>>
>>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20140405/4ccd680a/attachment.html>