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 your items 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:

    
  1. Re: Tax Rates returns only 0.00 (Bob/Amelia McPeak 2000)
  2. Re: Tax Rates returns only 0.00 (Robert McPeak 2000)
  3. Re: Tax Rates returns only 0.00 (Jesse Proudman 2000)
  4. Re: Tax Rates returns only 0.00 (Aaron Lynch 2000)
  5. Re: Tax Rates returns only 0.00 (Nicolas Verhaeghe 2000)
  6. Tax Rates returns only 0.00 (Robert McPeak 2000)
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 your items 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)