Hi Alex, I tried :
if(!is_avp_set("$avp(s:lnp_prefix)")){ xlog("alx ------- The new rU $rU with prefix $avp(s:lnp_prefix) return code:$retcode ----------"); } and it looks like is doing to right thing BUT why I don't see the avp value? I need this value to added in the front of rU as portability prefix.. Any comments about the sqlops ? Thank Alex On Mon, Dec 21, 2009 at 6:37 PM, Alex Balashov <abalas...@evaristesys.com>wrote: > 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.pap...@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:opense...@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@lists.kamailio.org >> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users >> http://lists.openser-project.org/cgi-bin/mailman/listinfo/users >> >
_______________________________________________ Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users