[Kamailio-Users] avpops OR sqlops

[Alex Balashov]

Alex,

Try:  if(is_avp_set("$avp(s:lnp_prefix)"))

--
Sent from mobile device

On Dec 21, 2009, at 11:19 AM, alex pappas <rebel.pappas at gmail.com>  
wrote:

> 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 at lists.kamailio.org
> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
> http://lists.openser-project.org/cgi-bin/mailman/listinfo/users