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...@lists.fedoraproject.org <mailto:trans-zh...@lists.fedoraproject.org>
https://admin.fedoraproject.org/mailman/listinfo/trans-zh_cn


_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Reply via email to