Re: Tax Rates returns only 0.00
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 30415
interpreted = N
texte = on 4/13/00 7:17 AM, Robert McPeak at rem1@access.mountain.net wrote:> Hey Folks--> > I'm making progress but I'm stumped. I can't get my Invoice.tpl to> return anything but 0.00 for the WV tax rate.> > Here's the applicable section from Invoice.tpl. My TaxRates.db and> Formulas.db follow. (This is all pulled from the TeaRoom files, more or> less.) Can anybody tell me why I return 0.00 for the WV tax rate? As> always: Thanks!!!!!> > Invoice.tpl:>
> [ShipTostate] Tax Rate: [taxRate]%> Tax | > $[taxTotal] | >
> >
> > Forumulas.db:> Name Formula> price [lookup> db=fitproducts.db&lookInField=sku&value=[sku]&returnField=price]> taxRate [lookup> db=TaxRates.db&lookInField=State&value=[ShipTostate]&returnField=taxRate¬Fo> und=0.00]> > shipCost [lookup> db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipCost]> > unitShipCost [lookup> db=fitproducts.db&lookInField=sku&value=[sku]&returnField=unitShipCost]> > TaxRates.db:> State taxRate> WV 6.00> Other 0.00> > -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to> do you have a taxable field in the database, and if so, are all of youritems set correctly.-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Associated Messages, from the most recent to the oldest:
on 4/13/00 7:17 AM, Robert McPeak at rem1@access.mountain.net wrote:> Hey Folks--> > I'm making progress but I'm stumped. I can't get my Invoice.tpl to> return anything but 0.00 for the WV tax rate.> > Here's the applicable section from Invoice.tpl. My TaxRates.db and> formulas.db follow. (This is all pulled from the TeaRoom files, more or> less.) Can anybody tell me why I return 0.00 for the WV tax rate? As> always: Thanks!!!!!> > Invoice.tpl:> > [ShipTostate] Tax Rate: [taxRate]%> Tax | > $[taxTotal] | >
> > > > Forumulas.db:> Name Formula> price [lookup> db=fitproducts.db&lookInField=sku&value=[sku]&returnField=price]> taxRate [lookup> db=TaxRates.db&lookInField=State&value=[ShipTostate]&returnField=taxRate¬Fo> und=0.00]> > shipCost [lookup> db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipCost]> > unitShipCost [lookup> db=fitproducts.db&lookInField=sku&value=[sku]&returnField=unitShipCost]> > TaxRates.db:> State taxRate> WV 6.00> Other 0.00> > -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to> do you have a taxable field in the database, and if so, are all of youritems set correctly.-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Aaron Lynch
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
WebCat2b15MacPlugin - showing [math] (1997)
pc (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
Updating product information (2002)
RE: IIS4b2 and WebCatalog b19 (1997)
[showif]/[hideif] question (1997)
New to WebCat, Help. (1998)
[WriteFile] problems (1997)
WebCatalog template cache (1998)
Using [Include] Context (1999)
Date search - yes or no (1997)
AAgghh!! Help, please. SSL strikes again. (1997)
Formvariables and Sendmail? (2000)
Need relative path explanation (1997)
Emailer Problem (2000)
WebCat2 beta 11 - new prefs ... (1997)
drop down selection list for a search (1998)
Date search bug (1998)
WebCat and WebTV (1997)
Keep away (1997)