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: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. Associated Messages, from the most recent to the oldest:

    
  1. Re: ShipCost and TaxRate problems (PCS Technical Support 1998)
  2. ShipCost and TaxRate problems (Karl Isselhardt 1998)
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:

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)