Re: Allowed fields in formulas.db

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 16800
interpreted = N
texte = >0) Is this WebCatalog 2.1x? Yes, as I said GenevaI am using the 30 day demo version of WebCat 2.1.1 on a mac >1) After you change a formula, do you issue a FlushDatabases command or otherwise quit WebCatalog so it knows to reload the formulas? Yes (quit befoe changes then restart WebCatalog) >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] Yes >3) Does your bigger formula work if you paste it into your Invoice.tpl page?> Invoice.tpl? As I said it works on an in-depth page about the item, I am trying to use the formula in the shopping cart template, have not got as far as an invoice yet. Hey i've just noticed a problem- I checked the admin page to see if my formulas.db was even being opened, it was, but showed 0 records 2 fields !I opened it up, but the price and formula are there, so somehow my formulas.db had been corrupted.I re-wrote it and now it works. Paul Willis 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)
>0) Is this WebCatalog 2.1x? Yes, as I said GenevaI am using the 30 day demo version of WebCat 2.1.1 on a mac >1) After you change a formula, do you issue a FlushDatabases command or otherwise quit WebCatalog so it knows to reload the formulas? Yes (quit befoe changes then restart WebCatalog) >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] Yes >3) Does your bigger formula work if you paste it into your Invoice.tpl page?> Invoice.tpl? As I said it works on an in-depth page about the item, I am trying to use the formula in the shopping cart template, have not got as far as an invoice yet. Hey i've just noticed a problem- I checked the admin page to see if my formulas.db was even being opened, it was, but showed 0 records 2 fields !I opened it up, but the price and formula are there, so somehow my formulas.db had been corrupted.I re-wrote it and now it works. Paul Willis Paul Willis

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:

IIS4 & Password Authentication, request example (1998) A quickie question (1997) Bulletin Board (1998) Multi Actions (1999) WebCatalog NT beta 18 problem (1997) [sendmail] questions... (1997) Mac Programs (1998) Forms & Tables (1998) A little help on e-mail (HELP!!! :-) ) (1998) emailer (1997) Using Plug-In while running 1.6.1 (1997) Using Cookie for client specific info? (1997) WebCat2: Formulas.db question (1997) Bug In Admin Templates (2003) UPDATE PROBLEM (1997) Search in 2 or more catalogs (1997) Passing a search through a form (2003) [WebDNA] Looking for Govinda (2011) WebCat2 - [include] tags (1997) RE: MacFinder -- a new WebDNA web site (1998)