[SR-Users] avp_db_query() question

Klaus Darilion klaus.mailinglists at pernau.at
Wed Jan 19 14:58:34 CET 2011


looks fine. try to increase debug level - then you should see the query 
and the results in syslog

regards
klaus

Am 18.01.2011 12:07, schrieb ºîÐñ¹â:
> 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 at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users



More information about the sr-users mailing list