ShipCost and TaxRate problems
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 21702
interpreted = N
texte = Hi all, I hope you can help me.I'm working on my first WebCat site, and I've run into problems with theInvoice.tpl page. I'm using a modified version of the TeaRoom exampleinvoice.tpl page, but the [taxRate] and [shipCost] fields are notshowing up. This means that [TaxTotal] and [shipTotal] are both leftblank.In short, NJ residents get charged 6% tax and everyone pays $8.00 forshipping. What is the easiest way for me to implement it?As I understand it, both of these tags are built-in with WebCat andshould have their values automatically filled in from the formulas.db.Here is what I have in the db for taxRate:[lookup db=TaxRates.db&lookInField=State[!][/!]&value=[ShipTostate]&returnField=taxRate¬Found=0.00]In the TaxRates.db I only have:State
taxRateNJ6.00But when I load the page, It shows 0%! It finds the [shipToState] andputs it in, but not the rate.The same thing is happening with [shipCost]. No matter what I try,(even pulling the formula out of the db and putting in a hidden formvariable) I still get $0.00Please help!Karl IsselhardtRaven Technologies, Inc.
Associated Messages, from the most recent to the oldest:
Hi all, I hope you can help me.I'm working on my first WebCat site, and I've run into problems with theInvoice.tpl page. I'm using a modified version of the TeaRoom exampleinvoice.tpl page, but the [taxRate] and [shipCost] fields are notshowing up. This means that [TaxTotal] and [shipTotal] are both leftblank.In short, NJ residents get charged 6% tax and everyone pays $8.00 forshipping. What is the easiest way for me to implement it?As I understand it, both of these tags are built-in with WebCat andshould have their values automatically filled in from the formulas.db.Here is what I have in the db for taxRate:[lookup db=TaxRates.db&lookInField=State[!][/!]&value=[ShipTostate]&returnField=taxRate¬Found=0.00]In the TaxRates.db I only have:StatetaxRateNJ6.00But when I load the page, It shows 0%! It finds the [shipToState] andputs it in, but not the rate.The same thing is happening with [shipCost]. No matter what I try,(even pulling the formula out of the db and putting in a hidden formvariable) I still get $0.00Please help!Karl IsselhardtRaven Technologies, Inc.
Karl Isselhardt
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:
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Re1000001: Setting up shop (1997)
Security (1998)
WebCatalog as a ListServ (1998)
truncating email part II (1997)
[Sum] function? (1997)
SHOWIF/HIDEIF empty fields (2005)
All choices on IE different than Netscape (1997)
remotely add + sign (1997)
I can help! (1996)
Nested search (1997)
database files in secure folder (1997)
A little help on e-mail (HELP!!! :-) ) (1998)
emailer (1997)
[protect] on NT? (1997)
gateway application timeouts (1998)
HTML Mail & Line breaks... (2004)
database paths/names, and a typo (1997)
Error Lob.db records error message not name (1997)
catching WebDNA error messages (2003)