[sr-dev] SQLOPS / sql_xquery & $dbr(result=>rows)

Brandon Armstead brandon at cryy.com
Mon Nov 26 21:29:10 CET 2012


Daniel,

   Indeed this seems to be the case at least in 3.2 - I guess I assumed
they would export the same pseudo variable access.

Is there any reason to use sql_xquery vs sql_query?

Looking through the source it seems they both now handle the same or
similar data types?

Sincerely,
Brandon Armstead


On Mon, Nov 26, 2012 at 12:21 PM, Daniel-Constantin Mierla <
miconda at gmail.com> wrote:

>  Hello,
>
> sql_xquery() does not set $dbr(...), but $xavp(...). And I don't think it
> sets any xavp with the number of rows and number of columns. The readme
> should have some examples, IIRC (not being the developer of this function).
>
> Cheers,
> Daniel
>
>
> On 11/26/12 9:16 PM, Brandon Armstead wrote:
>
> Hello,
>
>     Almost forgot to add - this is on Kamailio 3.2 --- checking master
> branch to see if there is any changes, but it does look like in 3.2
> res->nrows & res->ncols is not being set.
>
>
> On Mon, Nov 26, 2012 at 11:50 AM, Brandon Armstead <brandon at cryy.com>wrote:
>
>> Hello,
>>
>>     There appears to be an issue with the exported pseudo variable
>> $dbr(key=>rows).  I am receiving rows back that are being populated into
>> xavp via sql_xquery.  However the result of $dbr(key=>rows) is zero.
>>
>>  Perhaps I am doing something wrong or sql_xquery does not populate the
>> $dbr pseudo variable?
>>
>>  Thanks in advance.
>>
>>  Sincerely,
>> Brandon Armstead
>>
>
>
>
> _______________________________________________
> sr-dev mailing listsr-dev at lists.sip-router.orghttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
>
>
> --
> Daniel-Constantin Mierla - http://www.asipto.comhttp://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20121126/88f3aee1/attachment.htm>


More information about the sr-dev mailing list