Re: Allowed fields in formulas.db

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 16790
interpreted = N
texte = >In fact I just tried a simple formula: > >[math][lookup db=products.db&LookInField=SKU&value=NK1967&returnfield=price]*2[/math] > >and the same result. >Shouldn't the price be pulled automatically from the formulas.db if there is one?OK, let's start with some basics:0) Is this WebCatalog 2.1x?1) After you change a formula, do you issue a FlushDatabases command or otherwise quit WebCatalog so it knows to reload the formulas?2) If you truly have the following line in your formulas.db, case-sensitive for price, then do you also have a products.db in the same folder, with a SKU record exactly NK1967 case-sensitive and a price field?price [math][lookup db=products.db&LookInField=SKU&value=NK1967&returnfield=price]*2[/math]3) Does your bigger formula work if you paste it into your Invoice.tpl page?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: Allowed fields in formulas.db (Paul Willis 1998)
  2. Re: Allowed fields in formulas.db (PCS Technical Support 1998)
  3. Allowed fields in formulas.db (Paul Willis 1998)
>In fact I just tried a simple formula: > >[math][lookup db=products.db&LookInField=SKU&value=NK1967&returnfield=price]*2[/math] > >and the same result. >Shouldn't the price be pulled automatically from the formulas.db if there is one?OK, let's start with some basics:0) Is this WebCatalog 2.1x?1) After you change a formula, do you issue a FlushDatabases command or otherwise quit WebCatalog so it knows to reload the formulas?2) If you truly have the following line in your formulas.db, case-sensitive for price, then do you also have a products.db in the same folder, with a SKU record exactly NK1967 case-sensitive and a price field?price [math][lookup db=products.db&LookInField=SKU&value=NK1967&returnfield=price]*2[/math]3) Does your bigger formula work if you paste it into your Invoice.tpl page?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:

Welcome Back (was) Newbie Question (1999) WebDNA version? (2007) WC2b12: Yes, Formulas.db is for real (1997) FTP upload TCP Connect (2003) New syntax feedback for 4.0 (2000) AD Error Msg (1997) listfiles-looking for slick solution (1997) WCf2 and nested tags (1997) frames & carts (1997) Temp DB (Was freeze) (2003) Is there an alternative to emailer? (1999) Help! WebCat2 bug (1997) Trouble Searching (1999) New Featured Site (1999) Email (1998) PDF Example (2003) 2.01 upgrade problems (1997) Tab Charactor (1997) WebCatalog Technical Reference (1997) New Command prefs ... (1997)