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

Kelvin Chua


On Sat, Apr 5, 2014 at 6:16 PM, Fred Posner <fred@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@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


_______________________________________________
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