[Kamailio-Users] avpops OR sqlops

[alex pappas]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/users/attachments/20091221/32818f62/attachment.htm>