[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