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:
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:
Re[3]: 2nd WebCatalog2 Feature Request (1996)
Re:listfiles-looking for slick solution (1997)
Need WebDNA that crashes server for testing (2000)
WebCat2 beta 11 - new prefs ... (1997)
WebCat2b15MacPlugin - [protect] (1997)
[WebDNA] Query re: autonumber (2010)
Purchased cart being overwritten - still !?? (1997)
Confirming a bug/oddity (2003)
Running _every_ page through WebCat-error.html (1997)
WebDNA equivalent for $REQUEST_URI (2004)
formula part 3 (2000)
WebCat2b15MacPlugin - [protect] (1997)
Summing fields (1997)
WebDNA error. (2006)
[ModDate] & [ModTime] ? (1997)
help on brickwalls (2003)
Strange Search Results (2004)
Different Email recipients? (1998)
Notepad problems - SOLVED! (1998)
mass mailing (1998)