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!_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
