taxRate is fine but taxTotal isn't

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 15044
interpreted = N
texte = My formula for getting the tax rate in the taxRates.db is working just fine. It is finding the PA tax rate for pittsburgh at 7.0% and showing that on the shopping cart page. However, it is not multiplying the taxRate by the subTotal to get that taxtotal. Any thoughts?my Invoice part looks like this... Tax: [taxRate]% Tax $[taxTotal] and the formula for taxrate looks like this...[lookup db=TaxRates.db&lookInField=State&value=[ShipTostate]&returnField=taxRate¬Foun d=0.00]~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Michael Fichtenmayer - mike@steelnet.net Web Graphic Designer - Steelnet Communications http://www.steelnet.net Associated Messages, from the most recent to the oldest:

    
  1. Re: taxRate is fine but taxTotal isn't (Michael Fichtenmayer 1997)
  2. Re: taxRate is fine but taxTotal isn't (Kenneth Grome 1997)
  3. Re: taxRate is fine but taxTotal isn't (Raymond Hatch 1997)
  4. Re: taxRate is fine but taxTotal isn't (Michael Fichtenmayer 1997)
  5. Re: taxRate is fine but taxTotal isn't (Kenneth Grome 1997)
  6. taxRate is fine but taxTotal isn't (Michael Fichtenmayer 1997)
My formula for getting the tax rate in the taxRates.db is working just fine. It is finding the PA tax rate for pittsburgh at 7.0% and showing that on the shopping cart page. However, it is not multiplying the taxRate by the subTotal to get that taxtotal. Any thoughts?my Invoice part looks like this... Tax: [taxRate]% Tax $[taxTotal] and the formula for taxrate looks like this...[lookup db=TaxRates.db&lookInField=State&value=[ShipTostate]&returnField=taxRate¬Foun d=0.00]~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Michael Fichtenmayer - mike@steelnet.net Web Graphic Designer - Steelnet Communications http://www.steelnet.net Michael Fichtenmayer

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:

[shownext max=?] armed (1997) Buying sans cart (1997) Error Lob.db records error message not name (1997) [WebDNA] SMS Gateway (2013) wish list (2002) How can I Add several Items into the cart at once? (1997) HTTP upload (2000) a search based on ^(contains) (1998) Hiding HTML and page breaks (1997) Explorer 3.0/ Access Denied! (1997) createfolder not behaving as expected (1999) [OT] Disable/enable field (2003) Bug? (1997) Associative lookup style? (1997) NT vs Mac (1997) Anyone here care to chime in? (2005) WebMerchant and PC Auth Hub (1999) my price won't move (1997) Auto-email upon restart? (2001) Today's suggestions (1998)