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:

Separate SSL Server (1997) ooops...WebCatalog [FoundItems] Problem - LONG - (1997) Problems setting MIME Headers (1998) Cool new site (1996) is your webDNA site 'froogle' ready ??? (2003) Database causes out of memory error (2000) [OT] Disable/enable field (2003) Modifying order output (1997) Separate SSL Server (1997) WebCatalog vs. Cold Fusion (1998) Another bug to squash (WebCat2b13 Mac .acgi) (1997) Hello??? (1997) [LOOKUP] (1997) Picking a random entry from a .db (2001) OT: Safari/Mac - frames and iframes acting weird (2007) Shopping cart not being assigned (1999) Separate SSL Server (1997) question: back button prevention (1997) [OT] 'Email this story to a friend' (2003) [table] strange behaviour REAL solution (2003)