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.9530-60 6.9560-100 8.95100-150 10.95150-250 12.95250+ 16.95Standard Ship 0.00RUSH Ship 14.00In 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 ShipExtraStandard Shipping 0.00Rush 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 Providerhttp://www.pagehouse.com (509) 892-1973
Associated Messages, from the most recent to the oldest:
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.9530-60 6.9560-100 8.95100-150 10.95150-250 12.95250+ 16.95Standard Ship 0.00RUSH Ship 14.00In
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 ShipExtraStandard Shipping 0.00Rush 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 Providerhttp://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:
What am I missing (1997)
snicker, snicker (1997)
Conveting Characters to Graphics (1997)
RE: Migrating to NT (1997)
WebCatalog2 Feature Feedback (1996)
nested showif? (1998)
Converting characters to numbers ... (1997)
showif and cart (1997)
Checking two required fields (1998)
TRAINING videos - Prove IT. (1998)
OBDC Support (1997)
WCS Newbie question (1997)
WebCatalog can't find database (1997)
Trouble serving graphics on protected templates (1998)
WebDNA install on Tiger doesn't work ... (2005)
wierd [cart] action! (1997)
[OT] Linux Vs. OSX (leopard) server (2007)
UnitShipCost Slight Return (2003)
Context and commands (1998)
[ConvertChars] problem (1997)