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:

Shopping cart problem (2003) [WebDNA] trouble with [url] encoding??? (2014) Interfacing WebMerchant to www.fedex.com (1997) [WebDNA] WebDNA crash and now emailer not working (2010) Serving images from databases (1998) Execute Applescript (1997) [WebDNA] TCPconnect code snippet needed (2008) Frustration with formulas.db (1999) What is WebDNA (1997) Calculating multiple shipping... (1997) Writefile problem (1999) [carts] and databases (1997) Nesting format tags (1997) different ship dates and shopping carts -- how to? (1997) [WebDNA] bulk e-mail (2011) WebCatalog 4.0.1b2 is now available (2000) Great product and great job ! (1997) Error -108 (1997) Dummy Form Variables Needed (2000) RE: NewCart+Search with one click ? (1997)