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 Mail 0 5 17.95 30 8 19.95 60 11 21.95 90 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 90401 310.260.1700 x102 / 310.260.1701 FAX ken@chapsoft.com / www.chapsoft.com Associated Messages, from the most recent to the oldest:

    
  1. Re: Help with Shipping Costs (bob 1997)
  2. Re: Help with Shipping Costs (Ken Kohn 1997)
  3. Re: Help with Shipping Costs (Grant Hulbert 1997)
  4. Help with Shipping Costs (Ken Kohn 1997)
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 Mail 0 5 17.95 30 8 19.95 60 11 21.95 90 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 90401 310.260.1700 x102 / 310.260.1701 FAX ken@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)