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:
Problem with [Search] inside of [Loop]? (1997)
did I miss anything (1997)
Caching pages...again (2001)
form data submission gets truncated (1997)
Problem 2 of 2 (was: Shipping Confusion) (2000)
Duplicate Cart ID (2001)
Bug or syntax error on my part? (1997)
Execute Applescript (1997)
[getchars] questions (1997)
Email within tmpl ? (1997)
Mac 4.0b2 Installer Problems (2000)
Re:no [search] with NT (1997)
Webcat & MySQL Stored Procedures question -again (2005)
WebCat2: Formulas.db question (1997)
Secure Server not remembering discounts (1998)
100 + Users updating database (2002)
Type 11 errors setting up WebCAt 2 (1997)
Email and name capture (1999)
Embedded [Search] Context Snippets (Very Useful) (1998)
still having shipCost.db Problem (1997)