[OpenSIPS-Users] Regarding avp_db_query

Vishal Pai vishalmpai at gmail.com
Mon Nov 27 04:01:35 EST 2017


Thanks i got that....


On Mon, Nov 27, 2017 at 2:03 PM, Răzvan Crainea <razvan at opensips.org> wrote:

> Hi, Vishal!
>
> You can find the answer to your question in the function's documentation[1]:
> If the result gives many rows, then multiple AVPs with corresponding name
> will be added.
>
> Consider the following query:
> avp_db_query("select group where username='$tu'", "$avp(group)");
>
> The first line of the result can be accessed using $avp(group) (or
> $(avp(group)[0])), the second line $(avp(group)[1]), and so on.
>
> [1] http://www.opensips.org/html/docs/modules/2.4.x/avpops.html#idp3469424
>
> Best regards,
>
> Răzvan Crainea
> OpenSIPS Developerwww.opensips-solutions.com
>
> On 11/24/2017 08:56 PM, Vishal Pai wrote:
>
> Hi Everyone
>
> I just want to know what is correct to fetch all the row from database
> using avp_db_query. Currently I am getting only first row in result.
>
> One more think I want to know is it possible to get array of for variable
> in Opensips configuration file.
>
>
> Thanks
>
> Vishal Pai
>
>
> _______________________________________________
> Users mailing listUsers at lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20171127/bb10f14e/attachment.html>


More information about the Users mailing list