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:

Quit revisited (1997) Frames and WebCat (1997) Error -108 (1997) [date format] w/in sendmail (1997) Calculating multiple shipping... (1997) [WebDNA] a major shift in strategy? (2008) Re:quit command on NT (1997) RE: WebCatalog2 for NT Beta Request (1997) email program problem (1998) WebDNA for Window 2000 Server (2003) Weighting of grouped results possible? (was: grouping fieldsquestion) (1998) Nesting searches. (1998) [WebDNA] [replace] bug in v7.0? (2010) email error 159 (1998) serial number generation (1997) Multiple Stores and WebCatalog Prefs (1997) Announcing general availabilty of WebDNA 4.5 release (2002) PIXO support (1997) customer.db and forms (1999) [WebDNA] Has [middle] always worked this way? (2014)