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 the Invoice.tpl page. I'm using a modified version of the TeaRoom example invoice.tpl page, but the [taxRate] and [shipCost] fields are not showing up. This means that [TaxTotal] and [shipTotal] are both left blank.In short, NJ residents get charged 6% tax and everyone pays $8.00 for shipping. What is the easiest way for me to implement it?As I understand it, both of these tags are built-in with WebCat and should 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
taxRate NJ6.00But when I load the page, It shows 0%! It finds the [shipToState] and puts 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 form variable) I still get $0.00Please help!Karl Isselhardt Raven 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 the Invoice.tpl page. I'm using a modified version of the TeaRoom example invoice.tpl page, but the [taxRate] and [shipCost] fields are not showing up. This means that [TaxTotal] and [shipTotal] are both left blank.In short, NJ residents get charged 6% tax and everyone pays $8.00 for shipping. What is the easiest way for me to implement it?As I understand it, both of these tags are built-in with WebCat and should 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:StatetaxRate NJ6.00But when I load the page, It shows 0%! It finds the [shipToState] and puts 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 form variable) I still get $0.00Please help!Karl Isselhardt Raven 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:
security (1997)
[OT] See QT? (Was Eaaaasy FTP...) (2003)
problems with 2 tags (1997)
Initiating NewCart (1997)
Need relative path explanation (1997)
Webcatalog server support (1997)
unable to launch acgi in WebCat (1997)
thread7715.debug (1999)
Emailer Problem (1999)
gateway application timeouts (1998)
Format of Required fields error message (1997)
RE: Search (1997)
DocNote#2 - Random info is still wrong ... (2000)
Summary search -- speed (1997)
Searching multiple fields from one form field (1997)
math on date? (1997)
Multiple edits/replacementsd to db. Possible? (1997)
Image Library (2003)
HELP WITH DATES (1997)
WebCat2 as a chat server? (1997)