Shipping cost brain lock

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 23592
interpreted = N
texte = I am stumped. Seems to be happening a lot to me lately. Must need a vacation.My client wants- Shipping fees are as follows: $4.00 per pair of socks. $5.00 additional for 3rd Day Air. $9.00 additional for Next Day. Add $13.00 for international.My shipcost.db has UPS 4.00 Air3 5.00 NextDay 9.00 International 13My formula's db hasshipCost [lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipCost] unitShipCost [lookup db=mc.db&lookInField=sku&value=[sku]&returnField=unitShipCost] But as you can see they ant a base ship fee per package, but additional fees per order.Am I missing something simple here or is it really as complicated as it seems to be?thanks Alex Coded Out McCombie -- Alexander J. McCombie (800-724-8973) http://OurClients.com Corporate http://McCombie.com Personal (Alex@McCombie.com) http://Chat.Embark.com/ <--- Now here's a serious Chat Room! ---> Associated Messages, from the most recent to the oldest:

    
  1. Shipping cost brain lock (Alex McCombie 1999)
I am stumped. Seems to be happening a lot to me lately. Must need a vacation.My client wants- Shipping fees are as follows: $4.00 per pair of socks. $5.00 additional for 3rd Day Air. $9.00 additional for Next Day. Add $13.00 for international.My shipcost.db has UPS 4.00 Air3 5.00 NextDay 9.00 International 13My formula's db hasshipCost [lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipCost] unitShipCost [lookup db=mc.db&lookInField=sku&value=[sku]&returnField=unitShipCost] But as you can see they ant a base ship fee per package, but additional fees per order.Am I missing something simple here or is it really as complicated as it seems to be?thanks Alex Coded Out McCombie -- Alexander J. McCombie (800-724-8973) http://OurClients.com Corporate http://McCombie.com Personal (Alex@McCombie.com) http://Chat.Embark.com/ <--- Now here's a serious Chat Room! ---> Alex McCombie

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:

LOG IN LOG OUT (1997) WebCat2.0 [format thousands .0f] no go (1997) taxTotal, grandTotal (1997) [WebDNA] [sendmail] inside search (2016) WebCat2b13 Command Reference Doc error (1997) Dynamic Exchange Rates (2002) Extended [ConvertChars] (1997) [Sum] function? (1997) [shell] (2003) PIXO support (1997) Welcome! (2000) Transfer of data from Invoice to thank you templates (1998) Getting Total Quantity (1997) japanese characters (1997) Am I going senile? (Price recalc based on quantity) (1997) Make sure I understand this??? (1997) Comparing two fields so the match (1998) HELP WITH DATES (1997) Major Security Hole (1998) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)