Re: TaxTotal Problem
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 15070
interpreted = N
texte = >(I had sent this once this morning but nobody responded. PLEASE HELP!) > >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¬Fou >n >d=0.00]In your [lookup], try changing the notfound=0.00 to notfound=50 and see if the results changes. And make sure to flush the databases after making this change. Then, if the results are different from what you've been getting, that means the [lookup] is NOT finding the data you think it's finding ... :)Sincerely, Ken Grome WebDNA Solutions http://www.smithmicro.com/webdnasolutions/.
Associated Messages, from the most recent to the oldest:
>(I had sent this once this morning but nobody responded. PLEASE HELP!) > >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¬Fou >n >d=0.00]In your
[lookup], try changing the notfound=0.00 to notfound=50 and see if the results changes. And make sure to flush the databases after making this change. Then, if the results are different from what you've been getting, that means the
[lookup] is NOT finding the data you think it's finding ... :)Sincerely, Ken Grome WebDNA Solutions http://www.smithmicro.com/webdnasolutions/.
Kenneth Grome
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:
Make sure I understand this??? (1997)
Server Problem (2004)
Clickable maps and WebCatalog? (1996)
Database Structure? (1998)
Fun with dates (1997)
many-to-one problem (1998)
when is date system date or order date? (1997)
[WebDNA] Ajax, JS and WebDNA - A joint toturial ;-) (2010)
Why is my easy [AddLineItems] NOT working?? (2000)
Counting LineItems (2000)
Re:emailer 150 (1997)
URL'ed value not written to DB URL'ed (2003)
FREE Stuff .. (2003)
[delete] problem (1997)
Trouble creating a temp database (2000)
WebCatalog-NT?'s (1996)
updating with ProductEditor (1998)
Sorting Numbers (1997)
WebCatalog and Linux (2000)
WC TableGrinder (1997)