[SR-Users] sql_xquery() and xavp checks

[Alex Balashov]

Does that work for SELECT queries? The documentation says it's only for INSERT, UPDATE and DELETE. 


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>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
>> 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

--
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20140406/d2620f05/attachment.html>