Re: Tax Rates returns only 0.00

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 30417
interpreted = N
texte = Thanks guys for your replies! I think the Nicolas' [set header] looks like a good solution, although I do want to know why my formulas.db ain't working. Thanks for the help!!Aaron Lynch wrote:> 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 ------------------------------------------------------------- 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)
Thanks guys for your replies! I think the Nicolas' [set header] looks like a good solution, although I do want to know why my formulas.db ain't working. Thanks for the help!!Aaron Lynch wrote:> 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 ------------------------------------------------------------- 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 Robert McPeak

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:

Item counting? (1998) RAM variables (1997) 2.1 bugs left over from beta cycle (1998) show all problem (1997) WC2.0 Memory Requirements (1997) running WebCatalog under Apache on NT? (2000) WebMerchant problem (1998) taxTotal (1997) Alternative To WebDNA? (2006) WebCat2b13MacPlugin - [math][date][/math] problem (1997) 'page impression' techniques for banner ads (1999) HTML Editors (1997) Two submit buttons ? (1997) If Empty ? (1997) Trouble with Netscape (1998) Fun with Dates - revisited (1997) Customizing WebDelivery.html (1998) Setting up shop (1997) any suggestions for creating a multi-lingual site? (1999) [WebDNA] how to purge webdna cache of templates? (2009)