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:

WebCat for Unix?? (1997) Error Lob.db records error message not name (1997) [OT] Help Webcat 213 win (2000) Hiding Contexts (2000) NT b19 sends extra MIME headers (1997) WebCat2 beta 11 - new prefs ... (1997) WebCAT 3.x (2002) WebDNA Solutions --> Date format suggestions (1998) Protecting Images (2003) lookups or math? (1998) Dynamic drop downs (2005) [WebDNA] Best practice re: password storage (2013) Incrementing a number (1998) 2.0 Info (1997) Problem searching bw & ne of a word (1999) [TCPConnect] questions/problems (2001) [SQL] & ODBC on Mac - Reposted (2000) WCS Newbie question (1997) Re:Problem displaying search result (1997) WebCatalog [FoundItems] Problem - LONG - (1997)