Calculating Shipping charges for multiple items and qtys > 1

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 13747
interpreted = N
texte = We are trying to create a basket store where shipping method is multiplied by quantity. For example UPSGROUND which is 8.95, is multiplied by quantity. I tried writing the following formula in the file formulas.db: [math][totalqty][lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=SHIPCOST ][/math]Totalqty is a function where totalqty=totalqty+[quantity].Can anyone tell me why this didn't work? Thanks,Chris Martin Virtualrep Associated Messages, from the most recent to the oldest:

    
  1. Calculating Shipping charges for multiple items and qtys > 1 (updates@virtualrep.com (Updates) 1997)
We are trying to create a basket store where shipping method is multiplied by quantity. For example UPSGROUND which is 8.95, is multiplied by quantity. I tried writing the following formula in the file formulas.db: [math][totalqty][lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=SHIPCOST ][/math]Totalqty is a function where totalqty=totalqty+[quantity].Can anyone tell me why this didn't work? Thanks,Chris Martin Virtualrep updates@virtualrep.com (Updates)

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:

Fun with Dates - finally resolved but.... (1997) RE: URL too Long? (1997) Copyright that puppy (1998) Problems with [Search] param - Mac Plugin b15 (1997) [WriteFile] problems (1997) Variable Sizes, Widths and Colors (2000) [WebDNA] WebDNA future (2010) Major Security Hole IIS NT (1998) More questions about serial number dishing (1997) Multiple Choices in One Entry - Clothing Sizes (2000) insert graphic in email (2000) Multiple Choices in One Entry - Clothing Sizes (2000) [convertChars] and HTML Tags (1997) [WebDNA] [convertchars] and ascii problem (2010) japanese characters (1997) Online docs errata (2000) P1: How to make webcatalog more stable. - LONG (1999) encrypted query string trouble on OSX (2001) WCS Newbie question (1997) RE: creating writefile data from a nested search (1997)