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:

"Advanced" Search Algorithm (2008) Re[2]: Re[2]: OT: Amazon Patents (2000) duplicate cart numbers (2002) WC Database Format (1997) This message couldn't reach the list! (multi-column (1998) Forms Search Questions (1997) page redirect in webDNA (1997) Limit on nested [ShowIf]'s? (1997) NT or Mac (1998) [WebDNA] Range calculation w/negative values (2011) [OT] Linux -> Winderz (2005) Resume Catalog ? (1997) [WebDNA] 6.2 Monitor (2012) Multiple catalog databases and showcart (1997) Subject: Authenticating users without dialog box (1997) ooops...WebCatalog [FoundItems] Problem - LONG - (1997) Sort Order on a page search (1997) server not running. (2003) HTML (1999) If Empty ? (1997)