Re: formula inside database to calculate weights
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 15814
interpreted = N
texte = >I have some products that have weights that depend upon which options are >chosen. I tried to put the formula for calculating the weights inside >the [weight] field. But this WebDNA is not evaluated when the data field >is retrieved. If I display the [weight] field, it displays the whole >formula in all the gory WebDNA detail. > >I thought this should work. What am I missing?You have to put the [weight] field inside an [interpret] context.The formulas.db works *without* doing this, because the formulas.db is recognized by WebCat as a special database, so all the fields in that db are automatically [interpret]ed. But you're trying to do the same thing in another database, so you have to use the [interpret] context ... :)Sincerely, Ken Grome ken@iav.com 808-737-6499 WebDNA Solutions http://webdna.net/
Associated Messages, from the most recent to the oldest:
>I have some products that have weights that depend upon which options are >chosen. I tried to put the formula for calculating the weights inside >the [weight] field. But this WebDNA is not evaluated when the data field >is retrieved. If I display the [weight] field, it displays the whole >formula in all the gory WebDNA detail. > >I thought this should work. What am I missing?You have to put the [weight] field inside an
[interpret] context.The
formulas.db works *without* doing this, because the
formulas.db is recognized by WebCat as a special database, so all the fields in that db are automatically
[interpret]ed. But you're trying to do the same thing in another database, so you have to use the
[interpret] context ... :)Sincerely, Ken Grome ken@iav.com 808-737-6499 WebDNA Solutions http://webdna.net/
Kenneth Grome
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:
[shownext max (1997)
Document Contains No Data msg (1997)
Only charge card when product shipped ? (1997)
Problems mit mysql (2004)
[isfile] ? (1997)
A question about security (1998)
Re[4]: Problem with new formvariables (2000)
WebCatalog vs. Cold Fusion (1998)
[WebDNA] Array for Dummies (2010)
Hiding Email Addresses (2003)
Multipart/alternative e-mail (2003)
Bug Report, maybe (1997)
Database Options (1997)
carriage returns in data (1997)
How Many SKU's is enough? (1997)
Need help with emailer- 2 issues (1997)
Time/date formatting %X doesn't work ... (1997)
using showpage and showcart commands (1996)
Almost a there but..bye bye NetCloak (1997)
international time (1997)