Hi,
I'm having trouble matching tariff using sqlbill in gnugk-2.2.5 updated
from cvs few days ago.
I checked match_tariff function and it checks first exact match and then
if no exact match it continues further.
And then the following query tries to find tariff destination. I put
real values in places and tried to run query:
SELECT INTO dst.id, dst.active, trf.id D.id, D.active, T.id FROM
voiptariffdst D LEFT JOIN voiptariff T ON T.dstid = D.id LEFT JOIN
voiptariffgrp G ON T.grpid = G.id LEFT JOIN voiptariffsel S ON S.grpid =
G.id WHERE NOT D.exactmatch AND ('089881038983560' LIKE (D.prefix ||
'%')) AND NOT T.terminating AND T.currencysym = 'USD' AND (T.grpid IS
NULL OR S.accountid = 1) ORDER BY length(D.prefix) DESC,
COALESCE(G.priority,-2147483648) DESC LIMIT 1;
I don't understand here ('089881038983560' LIKE (D.prefix || '%')) part.
It doesn't match here.
In my opinion it should be something like: match longest possible prefix.
Is it possible to do this? Can you help me in this regard?
thanks a lot,
Ganbold
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________________
Posting: mailto:[email protected]
Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549
Unsubscribe: http://lists.sourceforge.net/lists/listinfo/openh323gk-users
Homepage: http://www.gnugk.org/
