no, it's not for SELECT. $dbr for SELECTs Kelvin Chua
On Sat, Apr 5, 2014 at 6:16 PM, Fred Posner <f...@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 <kel...@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 >> <abalas...@evaristesys.com <mailto:abalas...@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-us...@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 >
_______________________________________________ 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
