Re: Cumulative Shipping charge calculations - your help please.

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 13798
interpreted = N
texte = >Name Formula >shipCost >[lineItems]ath]>[/lineItems][math][lookup >db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=SHIPCOST] >*[totalqty][/math]The Formulas.db file does not contain HTML -- it contains math formulas. Things like do not belong there, because
    
  1. Re: Cumulative Shipping charge calculations - your help please. (Grant Hulbert 1997)
  2. Cumulative Shipping charge calculations - your help please. (updates@virtualrep.com (Updates) 1997)
>Name Formula >shipCost >[math]totalqty=0[/math]>[lineitems][math]totalqty=totalqty+[quantity][/m >ath]>[/lineItems][math][lookup >db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=SHIPCOST] >*[totalqty][/math]The formulas.db file does not contain HTML -- it contains math formulas. Things like [math]> do not belong there, because [math]...[/math] and the interior has to be just numerical stuff.[lineitems][quantity]+[/lineitems] will generate 10+3+5+9+You need something like([lineitems][quantity]+[/LineItems]0)*[lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=SHIPCOST]which will end up looking something like the following to WebCatalog(10+3+5+9+0)*7.50Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ==== Pacific Coast Software | WebCatalog, WebMerchant 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com Grant Hulbert

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:

Bug Report, maybe (1997) color and size options / ARCHIVES (1997) Error: Can't open order file. (2005) Num Sort Descending (2004) foreign languages, email, webcat (1998) Calculating multiple shipping... (1997) Sticky .inc file! (2008) shipping costs (1997) New Command prefs ... (1997) Rhapsody? (1997) New user...how do I create URLs from form fields? (2000) Friday night shopping site joke (1997) cart (1997) Status? (2000) Emailer (WebCat2) (1997) WebCat & WebTen (1997) quantity minimum problem (1997) Erotic Sites (1997) Tea Room trouble (1997) no global [username] or [password] displayed ... (1997)