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/
