Re: formula.db problem

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 23361
interpreted = N
texte = Can anyone tell me why this formula in my formula.db isn't working?shipCost [lookup db=fed-x.db&lookInField=Lbs&value=[format .0f][search db=main2.txt&eqSKUdata=[sku]][founditems][Weight][/founditems][/search][/format]&returnField=11¬Found=nope]----------- [sku] is not available to the shipCost formula, because shipCost is considered a header ('global' to the entire order), so it has no idea *which* sku from the many lineitems you want applied to the formula. [SKU] is available when calculating the unitShipCost formula, because it applies to that particular lineitem. Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: formula.db problems (PCS Technical Support 1999)
  2. Re: formula.db problems (es-sleestak 1999)
  3. RE:formula.db problems (PCS Technical Support 1999)
  4. RE:formula.db problems (es-sleestak 1999)
  5. Re: formula.db problem (PCS Technical Support 1999)
  6. formula.db problem (Brant Wilcox 1999)
Can anyone tell me why this formula in my formula.db isn't working?shipCost [lookup db=fed-x.db&lookInField=Lbs&value=[format .0f][search db=main2.txt&eqSKUdata=[sku]][founditems][Weight][/founditems][/search][/format]&returnField=11¬Found=nope]----------- [sku] is not available to the shipCost formula, because shipCost is considered a header ('global' to the entire order), so it has no idea *which* sku from the many lineitems you want applied to the formula. [SKU] is available when calculating the unitShipCost formula, because it applies to that particular lineitem. Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ PCS Technical Support

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:

Text limits in NT version? (1997) Purchased cart being overwritten (1997) NT Setup (1998) [WC 2.1.30] Stack overflow. (2000) Bug Report, maybe (1997) [WebDNA] W3C Valid XHTML/CSS WebDNA Store templates (2009) WebCat2b13MacPlugIn - [include] (1997) EMailCompleted folder - How to process tags (2000) Dynamic Generation of PDFs? (2003) Using [showif] (2000) Search for starts with and ends with? (2003) I'm new be kind (1997) Major Security Hole (1998) Include vs. lookup? (1998) OSX Install error (2000) Web Catalog vs. ICAT (1997) writing orders to a db (1997) WebCat2 beta 11 - new prefs ... (1997) Not carrying Zero (2000) WebCat2b12 Mac.acgi--[searchstring] bug (1997)