Help with Shipping Costs
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 12889
interpreted = N
texte = I'm trying to get shipping costs to calculate properly based on the [subtotal]. It's not working. I keep getting a result of $0.00.In Formulas.db I have the following line:shipCost [lookup db=ShipCosts.db&value=[subTotal]&lookInField=totalCost&returnField=[shipvia]]and my ShipCosts.db looks like this:TotalCost UPS Express Mail0 5 17.9530 8 19.9560 11 21.9590 14 23.95As you can see, what I want to do is have eight different shipping costs based on shipping method and the subtotal. I'm using the [shipCost] in my invoice.tmpl file.I'm sure (and hope!) I'm missing something simple, but I don't know what it is.---------------------------------------------------------Ken Kohn Chaparral Software & Consulting Services, Inc.429 Santa Monica Blvd., Suite 230, Santa Monica, CA 90401310.260.1700 x102 / 310.260.1701 FAXken@chapsoft.com / www.chapsoft.com
Associated Messages, from the most recent to the oldest:
I'm trying to get shipping costs to calculate properly based on the [subtotal]. It's not working. I keep getting a result of $0.00.In
formulas.db I have the following line:shipCost [lookup db=ShipCosts.db&value=[subTotal]&lookInField=totalCost&returnField=[shipvia]]and my ShipCosts.db looks like this:TotalCost UPS Express Mail0 5 17.9530 8 19.9560 11 21.9590 14 23.95As you can see, what I want to do is have eight different shipping costs based on shipping method and the subtotal. I'm using the [shipCost] in my invoice.tmpl file.I'm sure (and hope!) I'm missing something simple, but I don't know what it is.---------------------------------------------------------Ken Kohn Chaparral Software & Consulting Services, Inc.429 Santa Monica Blvd., Suite 230, Santa Monica, CA 90401310.260.1700 x102 / 310.260.1701 FAXken@chapsoft.com / www.chapsoft.com
Ken Kohn
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:
Snake Bites (1997)
Digest for 09-30-97 (1997)
Re[3]: 2nd WebCatalog2 Feature Request (1996)
autosensing lanague selection (1997)
date formatting for CC card expiration date check (1998)
[sendmail] sending twice... (Update) (2003)
[WebDNA] WebDNA Hosting (2008)
Extended [ConvertChars] (1997)
The Form authentication trick (2000)
RE: Can't get appendfile to work (1997)
Hello??? (1997)
Single Link browsing (1997)
Buying sans cart (1997)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
Nav. 4 probs with cart (1997)
[WebDNA] behavior of [thisurl] in the context of 'mod_rewrite' (2012)
Bug in Mac webcatalog3_0_5b11 (1999)
[WebDNA] Domain upgrade questions (2009)
Creating 404 Not Found pages (1999)
logout after authenticated (2002)