Re: [Kamailio-Users] avpops OR sqlops

Hi all, I'm trying to make an sql query through my kamailio script in order to check for number portability. i have a table with 2 col (phonenumber,prefix). I'm trying both modules avpops and sqlops but I'm not able to retreive any data. modparam("avpops", "db_url","mysql://openser:openserrw@localhost/ openser") avp_db_query("SELECT prefix FROM ported WHERE phonenumber='$rU'","$avp(s:lnp_prefix)") ;The query run perfectly in command line. The return code is always 1 but when I print $avp(s:lnp_prefix) I get no result. I have 2 questions : 1. Which is the best way to check portability in my case 2. What I'm doing wrong and I'm not getting any result from the query. Thank you ALL Alex _______________________________________________ Kamailio (OpenSER) - Users mailing list Users(a)lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users