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:

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)