Hi all,<br><br>I&#39;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&#39;m trying both modules avpops and sqlops but I&#39;m not able to retreive any data.<br>
<br>modparam(&quot;avpops&quot;, &quot;db_url&quot;,&quot;mysql://openser:openserrw@localhost/openser&quot;)<br><br>avp_db_query(&quot;SELECT prefix FROM ported WHERE phonenumber=&#39;$rU&#39;&quot;,&quot;$avp(s:lnp_prefix)&quot;)  ;The query run perfectly in command line.<br>
<br>The return code is always 1 but when I print $avp(s:lnp_prefix) I get no result.<br><br>I have 2 questions :<br><br>1. Which is the best way to check portability in my case<br>2. What I&#39;m doing wrong and I&#39;m not getting any result from the query.<br>
<br>Thank you ALL<br><br>Alex<br><br><br>