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:
WebCat2b12 CGI Mac - [shownext] problem (1997)
WebCat editing, SiteGuard & SiteEdit (1997)
(1997)
What am I missing (1997)
[WebDNA] [announce] PC CICADA Build (2009)
Anyone awake? Newby moves deeper! Sitesearch & Customer DB Append Context or Command? (2000)
Searching multiple Databases (1997)
[searchString] (1997)
Add htmlarea 3 to SiteBuilder (2004)
[WebDNA] Testing (2016)
taxrate - off by 1 cent (1997)
woops - speed results - right subject (2002)
WebDNA Solutions ... (1997)
Multiple cart additions (1997)
Exclamation point (1997)
Running _every_ page through WebCat ? (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Fun with Dates - revisited (1997)
Comments in db? (1997)
PCS Frames (1997)