Hi,
Its great reply.
I want to use it for our VoIP Billing System. And my
NAS is cisco and i am sure the cisco is sending full
dialed telephone noumber with Called-Station-ID.
Because we are using MERA VoIP Softswitch and i asked
theirs eng. they told us Called-Station-ID is the full
dialed noumber.
So i think it looks like some sql query. i am able to
retrive the phone noumber in a perl variable.
I was trying in mySQL squery like:
$cod = $calledStationID
$sqld = "SELECT Rate FROM prefix_rate WHERE code LIKE
CONCAT(SUBSTRING($cod,3), '%')";
But it is not good for me. because some time our
customer puting in prefix_rate table country plus area
code so the substring should cut according to their
define length of code.
I hope this little example will be more clear in
understanding which i mean.
Thank You
Abdul Lateef
__________________________________
Celebrate Yahoo!'s 10th Birthday!
Yahoo! Netrospective: 100 Moments of the Web
http://birthday.yahoo.com/netrospective/
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html