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:

[movefile] (1999) CMSBuilder (2004) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) [WebDNA] WebDNA 8.6.4 (2020) Date search - yes or no (1997) WebCat2 - storing unformatted date data? (1997) Is [thisurl] http or https? (1998) WebCatalog 4.0.1 has been released! (2000) [BoldWords] WebCat.acgib15Mac (1997) multiple credit card merchant accounts/processors (1997) Building Calendars (1997) Will webdna execute before a [redirect]? (1999) [WebDNA] Search comparisons in 8.6.1 (2019) Multiple Pulldowns (1997) Forumulas.db & Variables (2002) [WebDNA] Searching for multiple bits of data in one field or use (2016) [WebDNA] Error: template... (2009) HELP - NONE STOP DIGESTS. Digest for 4/24/97) (1997) embedding [showcart] ??? (1998) logic help (1998)