ShipCost Data Base

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 19619
interpreted = N
texte = I am trying to get calculate our shipping cost for UPS Ground to vary based on a range of the total purchase price. I am using the following in my shipCosts.db:ShipMethod ShipCost UPS Ground [showif [subtotal]<10.01]4.95[/showif][showif [subtotal]>10.00][showif [subtotal]<25.01]5.95[/showif][/showif][showif [subtotal]>25.00][showif [subtotal]<50.01]7.50[/showif][/showif][showif [subtotal]>50.00][showif [subtotal]<75.01]8.95[/showif][/showif][showif [subtotal]>75.00][showif [subtotal]<150.01]9.95[/showif][/showif][showif [subtotal]>150.00][format.2f][math][subtotal]*.1[/math][/format][/showif] UPS Two-Day 10.00 Pick Up 0.00 (There is a space between UPS and Ground and tab before the formula)The formula recognized the UPS Ground and returns it into my invoice properly, but the formula doesn't work. Any suggestions as to what I'm doing wrong?Richard Kirsner Competitive Edge, Inc. Associated Messages, from the most recent to the oldest:

    
  1. Re: ShipCost Data Base (Kenneth Grome 1998)
  2. Re: ShipCost Data Base (Richard Kirsner 1998)
  3. Re: ShipCost Data Base (Kenneth Grome 1998)
  4. Re: ShipCost Data Base (bob 1998)
  5. ShipCost Data Base (Richard Kirsner 1998)
I am trying to get calculate our shipping cost for UPS Ground to vary based on a range of the total purchase price. I am using the following in my shipCosts.db:ShipMethod ShipCost UPS Ground [showif [subtotal]<10.01]4.95[/showif][showif [subtotal]>10.00][showif [subtotal]<25.01]5.95[/showif][/showif][showif [subtotal]>25.00][showif [subtotal]<50.01]7.50[/showif][/showif][showif [subtotal]>50.00][showif [subtotal]<75.01]8.95[/showif][/showif][showif [subtotal]>75.00][showif [subtotal]<150.01]9.95[/showif][/showif][showif [subtotal]>150.00][format.2f][math][subtotal]*.1[/math][/format][/showif] UPS Two-Day 10.00 Pick Up 0.00 (There is a space between UPS and Ground and tab before the formula)The formula recognized the UPS Ground and returns it into my invoice properly, but the formula doesn't work. Any suggestions as to what I'm doing wrong?Richard Kirsner Competitive Edge, Inc. Richard Kirsner

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:

Download (1999) Trouble with my database (1998) Nested Loops and SHOWIFs (1997) WebCatalog can't find database (1997) (2004) Problems with [Applescript] (1997) More to Expire (1998) WebCat2b15MacPlugIn - [authenticate] not [protect] (1997) WebCat templates for TyphoonPro admin (1999) Image download problem (2001) WebCat2b15MacPlugin - [protect] (1997) WebCatalog for Postcards ? (1997) ListFields and [name] (1997) Ooops-Serial Number for NT (1997) credit card services (1997) Date Calulation (1997) Can't get appendfile to work (1997) Help with [LineItems] in [OrderFile] on ShoppingCart.tpl (2003) hidden databases (2000) WC2b15 File Corruption (1997)