[SR-Users] sql_xquery() and xavp checks

[Fred Posner]

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
>