Shipping still a problem!!

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 21848
interpreted = N
texte = Will someone PLEASE help me out with a straight answer here!The situation:I have to charge shipping based on this formula - shipVia * total number of items orderedexample - Canada UPS $15.00 * 3 copies of software = $45.00 Example data is:in the mainevent.db - SKU Title Price Domestic Canada Intnl 001 PhotoScripter - Single User 299.00 7 15 25 002 Scripter 2 199.00 7 15 25 003 ScriptBase 59.00 7 15 25in Formulas.db - Name Formula shipCost [lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipCost]unitShipCost [lookup db=mainevent.db&lookInField=sku&value=[sku]&returnField=[shipVia]]in ShipCosts.db - ShipMethod ShipCost Domestic 7.00 Canada 15.00 Intnl 25.00On the Invoice I cakll for unitShipCost and shippingTotalCan someone tell me what's going wrong?Thanks,Jim Associated Messages, from the most recent to the oldest:

    
  1. Re: Shipping still a problem!! (John W 1998)
  2. Re: Shipping still a problem!! (PCS Technical Support 1998)
  3. Shipping still a problem!! (Jim O'Connor 1998)
Will someone PLEASE help me out with a straight answer here!The situation:I have to charge shipping based on this formula - shipVia * total number of items orderedexample - Canada UPS $15.00 * 3 copies of software = $45.00 Example data is:in the mainevent.db - SKU Title Price Domestic Canada Intnl 001 PhotoScripter - Single User 299.00 7 15 25 002 Scripter 2 199.00 7 15 25 003 ScriptBase 59.00 7 15 25in formulas.db - Name Formula shipCost [lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipCost]unitShipCost [lookup db=mainevent.db&lookInField=sku&value=[sku]&returnField=[shipVia]]in ShipCosts.db - ShipMethod ShipCost Domestic 7.00 Canada 15.00 Intnl 25.00On the Invoice I cakll for unitShipCost and shippingTotalCan someone tell me what's going wrong?Thanks,Jim Jim O'Connor

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:

Hard Questions ? (1997) 2.0Beta Command Ref (can't find this instruction) (1997) Is this possible, WebCat2.0 and checkboxes (1997) Random sort is not random at all..... (2000) build a select list from a db search (2004) [WebDNA] El Capitan with WebDNA 8.1 fastCGI (2015) [addlineitems] as oppossed to url command=add (2000) WebCat2b12 Mac.acgi--[searchstring] bug (1997) sendmail doesn't send on Linux (2001) bug ? causes NT event log to fill (1997) Multi-Row Tables from a search. (1997) WC2.0 Memory Requirements (1997) Crazy dates (was: sorting dates) (1999) Expiration of Carts (1997) [Fwd: internet tax] (2001) [WebDNA] WebDNA on LiveCD ... (2008) Error Lob.db records error message not name (1997) WebCat2b15MacPlugin - showing [math] (1997) best way to test for the existence of a parameter in a url (2003) Multiple prices (1997)