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:

Mac Scheduling (1998) DON'T use old cart file! (1997) 2nd WebCatalog2 Feature Request (1996) email error 159 (1998) RE: NewCart+Search with one click ? (1997) WC TableGrinder (1997) Personal Web Server (1998) tcpconnect/tcpsend frustrations (2002) [authenticate] (1999) Clickable maps and WebCatalog? (1996) Help!!!! (1997) Sub Totals (2000) Size limit for tmpl editor ? (1997) Modulo function? (2000) WebCat on 10.0.4 - iTools 6.0 (2001) Change History for Win 4.0.1 (2000) Can I invoke an ssi plugin from within a webcat page (1997) Porting to NT (2001) FORMS!! (2001) Just Testing (1997)