Re: [SR-Users] sql_xquery() and xavp checks

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@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@evaristesys.com <mailto:abalashov@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@lists.sip-router.org <mailto:sr-users@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@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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users