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 daydemo version of WebCat 2.1.1 on a mac>1) After you change a formula, do you issue aFlushDatabases command or otherwise quit WebCatalog so it knows toreload 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 thesame folder, with a SKU record exactly NK1967 case-sensitive and aprice field?>price [math][lookupdb=products.db&LookInField=SKU&value=NK1967&returnfield=price]*2[/math]Yes>3) Does your bigger formula work if you paste it into your Invoice.tplpage?> Invoice.tpl? As I said it works on an in-depth page about the item, Iam trying to use the formula in the shopping cart template, have notgot 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 beingopened, it was, but showed 0 records 2 fields !I opened it up, but the price and formula are there, so somehow myformulas.db had been corrupted.I re-wrote it and now it works.Paul Willis
Associated Messages, from the most recent to the oldest:
>0) Is this WebCatalog 2.1x?Yes, as I said GenevaI am using the 30 daydemo version of WebCat 2.1.1 on a mac>1) After you change a formula, do you issue aFlushDatabases command or otherwise quit WebCatalog so it knows toreload 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 thesame folder, with a SKU record exactly NK1967 case-sensitive and aprice field?>price [math][lookupdb=products.db&LookInField=SKU&value=NK1967&returnfield=price]*2[/math]Yes>3) Does your bigger formula work if you paste it into your Invoice.tplpage?> Invoice.tpl? As I said it works on an in-depth page about the item, Iam trying to use the formula in the shopping cart template, have notgot 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 beingopened, it was, but showed 0 records 2 fields !I opened it up, but the price and formula are there, so somehow myformulas.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)