avp_db_query() question - sr-users

18 Jan 2011

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 inhttp://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!