formula inside database to calculate weights

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 15815
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?Here's the formula in question...[math show=f]weight=xx[/math][math][showif [Lookup db=option1.db&lookInField=optkey1&value=[textA]&returnField=mscode1]=DZ]12* [/showif]weight[/math] where xx is the weight of the product when single, instead of a dozen.ThanksSandy Associated Messages, from the most recent to the oldest:

    
  1. Re: formula inside database to calculate weights (Grant Hulbert 1997)
  2. formula inside database to calculate weights (Sandra L. Pitner 1997)
  3. Re: formula inside database to calculate weights (Kenneth Grome 1997)
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?Here's the formula in question...[math show=f]weight=xx[/math][math][showif [Lookup db=option1.db&lookInField=optkey1&value=[textA]&returnField=mscode1]=DZ]12* [/showif]weight[/math] where xx is the weight of the product when single, instead of a dozen.ThanksSandy Sandra L. Pitner

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:

killing white space (1998) WebCatalog 2.0 b 15 mac (1997) Version 4? (2000) groups and [ShowNext] (1997) In Digest Dijon (2000) [SearchString] problem with [search] context (1997) Gathering the values of matching fields in a database. (1998) WebCatalog 4 Install Problems - Not Answered ?? (2000) RE: WebCatalog NT beta 18 now available (1997) Nested tags count question (1997) absolute paths for databases? (1997) [WebDNA] Some code inside a large loops fail ... but why? (2010) posts (1998) SiteEdit NewFile.html ? (1997) Re:redirect from the errorsMessages.db entry (1997) Formating found categories (1997) WebCatalog for guestbook ? (1997) problems with 2 tags (1997) Extra equals signs with IE? (More debugging questions...) (1997) (1997)