Re: [SR-Users] avp_db_query() question

Hello |avp_db_query(query[,dest]) can get a database query and store the results in the avps.| |But what if the results returns many rows,and how can I get all the results? How to set the [dest] parameter ?| |I've tried the method describered in http://www.kamailio.org/docs/avp_db_query.html,but it doesn't work.| |like below| |mysql<select mem_user from tgroup where grp_name='1234';| |+----------+| || mem_user || |+----------+| || 1013 || || 2013 || |+----------+| |2 rows in set (0.00 sec)| |kamailio.cfg| |if(avp_db_query("select mem_user from tgroup where grp_name='1234'","$avp(name)"))| |{| |||xlog("L_INFO","query results[1] :$avp(name[1])\n");| |xlog("L_INFO","query results[2] :$avp(name[2])\n");| |}| |syslog| |<INFO> query results[1] :<null>| |<INFO> query results[2] :<null>| |version: kamailio 3.0.2 MySQL 5.0| || |thank you very much!| _______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users(a)lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users