[OpenSIPS-Users] How to save avp-values to singal attribute name in cache_store?

[Bogdan-Andrei Iancu]

Hello,

The avp_db_query() stores the DB result (multiple rows with multiple 
columns) into a set of AVPs (kind of an array). See
http://www.opensips.org/html/docs/modules/2.2.x/avpops.html#id293973

Using a while loop (see 
http://www.opensips.org/Documentation/Script-Statements-2-2#toc3), you 
can iterate throw all the rows, by checking the if 
$(avp(xxx)[$var(idx)]) is NULL or not (where $var(idx) is the variable 
in the while loop).

Inside the loop, simply store the row (all the AVPs with that index) 
into cache DB .

Regards,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com

On 18.09.2016 12:15, xiaofeng wrote:
> Hi there,
>
> I want to save several avp_db_query-values to one attribute use 
> cache_store at startup, how to do that?
>
> Thanks.
>
> -- 
> xiaofeng
>
> --
> gpg key fingerprint:
> 2048R/5E63005B
> C84F 671F 70B7 7330 4726  5EC8 02BC CBA2 5E63 005B
> --
> trans-zh_cn mailing list
> trans-zh_cn at lists.fedoraproject.org 
> <mailto:trans-zh_cn at lists.fedoraproject.org>
> https://admin.fedoraproject.org/mailman/listinfo/trans-zh_cn
>
>
> _______________________________________________
> 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/20160920/c408ec4c/attachment.htm>