You can also checkout the latest SqlBill from the cvs - it contains a more convenient way to setup tariffs - via an OpenOffice Calc spreadsheet. On Fri, 2004-08-13 at 04:11, Abano, Fernando A. (ePerformax) wrote: > Hi Michal, > > I am still attempting to make sqlbill work. The diffence between your > sample voiptariffdst/voiptariff and mine is in the prefix where for > example, my prefix=1 while in the sample, it is 001 for the USA. I have > edited that prefix in the table to reflect 1 instead of 001 but it still > would not compute the price. I then simulated the query and below is the > result: > > select * from voiptariffdst where active and > ascii(prefix)=ascii('19017154800') and ('19017154800' like (prefix || > ''%'')) limit 1; > > And got this result: > > ERROR: operator is not unique: "unknown" % "unknown" > HINT: Could not choose a best candidate operator. You may need to add > explicit type casts. > > I changed the query to: > > select * from voiptariffdst where active and > ascii(prefix)=ascii('19017154800') and ('19017154800' like (prefix || > '%')) limit 1; > > And got : > > id | active | prefix | description > ----+--------+--------+------------- > 57 | t | 1 | USA > (1 row) > > It appears that the double single quote near the % was creating an error > in match_tariff. > > Is my finding correct? ------------------------------------------------------- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 _______________________________________________________ List: Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549 Homepage: http://www.gnugk.org/