21 Dec
2009
21 Dec
'09
8:17 p.m.
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 <abalashov(a)evaristesys.com>wrote;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.pappas(a)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(a)lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
http://lists.openser-project.org/cgi-bin/mailman/listinfo/users