Re: Ship Cost Calculated via Subtotal

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 21083
interpreted = N
texte = David,Here's one that compares based on subtotal and then it goes to the ShipCosts.db to see if there is any additional cost for RUSH shipping versus STANDARD shipping.The breaks are < 30 4.95 30-60 6.95 60-100 8.95 100-150 10.95 150-250 12.95 250+ 16.95Standard Ship 0.00 RUSH Ship 14.00 In formulas.dbshipCost [hideif [subTotal]>30.00][showif [subTotal]<30.00][math]4.95+[lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipExtra][/m ath][/showif][/hideif][hideif [subTotal]>60.00][showif [subTotal]<60.00][math]6.95+[lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipExtra][/m ath][/showif][/hideif] [hideif [subTotal]>100.00][showif [subTotal]<100.00][math]8.95+[lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipExtra][/m ath][/showif][/hideif] [hideif [subTotal]>150.00][showif [subTotal]<150.00][math]10.95+[lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipExtra][/m ath][/showif][/hideif] [hideif [subTotal]>250.00][showif [subTotal]<250.00][math]12.95+[lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipExtra][/m ath][/showif][/hideif][hideif [subTotal]>100000.00][showif [subTotal]<100000.00][math]16.95+[lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipExtra][/m ath][/showif][/hideif] In ShipCosts.dbShipMethod ShipExtra Standard Shipping 0.00 Rush Shipping 14.00Hope it helps.Bill >Hello > I would like to calculate the shipping cost based on the subtotal. >Could someone show me the best way to do this. What I would like to do >is have a database that holds the cost of shipping. If the subtotal is >less than or equal to $25 dollars make the shipping cost $10. > >Subtotal ShipCost >Subtotal <= $25 $10 >Subtotal <= $75 $7 >Subtotal <= $100 $3 > >Thank You In Advance >David Greensfelder >Origin Technology In Business >8044 Montgomery Rd. Suite 200W >Cincinnati, Ohio 45236 >513-985-1414 >david.greensfelder@us.origin-it.com -- Bill Heissenbuttel PageHouse, Inc. bill@pagehouse.com Internet Presence Provider http://www.pagehouse.com (509) 892-1973 Associated Messages, from the most recent to the oldest:

    
  1. Re: Ship Cost Calculated via Subtotal (Bill Heissenbuttel 1998)
  2. Re: Ship Cost Calculated via Subtotal (PCS Technical Support 1998)
  3. Ship Cost Calculated via Subtotal (Greensfelder, David 1998)
David,Here's one that compares based on subtotal and then it goes to the ShipCosts.db to see if there is any additional cost for RUSH shipping versus STANDARD shipping.The breaks are < 30 4.95 30-60 6.95 60-100 8.95 100-150 10.95 150-250 12.95 250+ 16.95Standard Ship 0.00 RUSH Ship 14.00 In formulas.dbshipCost [hideif [subTotal]>30.00][showif [subTotal]<30.00][math]4.95+[lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipExtra][/m ath][/showif][/hideif][hideif [subTotal]>60.00][showif [subTotal]<60.00][math]6.95+[lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipExtra][/m ath][/showif][/hideif] [hideif [subTotal]>100.00][showif [subTotal]<100.00][math]8.95+[lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipExtra][/m ath][/showif][/hideif] [hideif [subTotal]>150.00][showif [subTotal]<150.00][math]10.95+[lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipExtra][/m ath][/showif][/hideif] [hideif [subTotal]>250.00][showif [subTotal]<250.00][math]12.95+[lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipExtra][/m ath][/showif][/hideif][hideif [subTotal]>100000.00][showif [subTotal]<100000.00][math]16.95+[lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipExtra][/m ath][/showif][/hideif] In ShipCosts.dbShipMethod ShipExtra Standard Shipping 0.00 Rush Shipping 14.00Hope it helps.Bill >Hello > I would like to calculate the shipping cost based on the subtotal. >Could someone show me the best way to do this. What I would like to do >is have a database that holds the cost of shipping. If the subtotal is >less than or equal to $25 dollars make the shipping cost $10. > >Subtotal ShipCost >Subtotal <= $25 $10 >Subtotal <= $75 $7 >Subtotal <= $100 $3 > >Thank You In Advance >David Greensfelder >Origin Technology In Business >8044 Montgomery Rd. Suite 200W >Cincinnati, Ohio 45236 >513-985-1414 >david.greensfelder@us.origin-it.com -- Bill Heissenbuttel PageHouse, Inc. bill@pagehouse.com Internet Presence Provider http://www.pagehouse.com (509) 892-1973 Bill Heissenbuttel

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:

How many lookups does it take ... (2003) Multiple Passwords (1997) WML (2000) Updating fields from different platforms (1998) Tcp Connect and the disappearing page (2000) [include file=filename.inc&strip=t] (2002) Need Advice for Setting up a Database (1999) Is this possible, WebCat2.0 and checkboxes (1997) WebCatalog2 Feature Feedback (1996) Documentation Feedback (1997) Security hole in WebCat? (1999) pull downs (1997) ooops...WebCatalog [FoundItems] Problem - LONG - (1997) [BULK] [WebDNA] [BULK] WebDNA 7 - Ready or Not ?? I'm not sure... (2011) Listfiles on network with NT (2000) [WriteFile] problems (1997) WC1.6 to WC2 date formatting (1997) OT- AS/400 and Macs (2003) WebStar and CopyFile (2000) Another question (1997)