Re: Help on how to store calculated value

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 45428
interpreted = N
texte = putting [lineitems] after the + will not work as you need a + after/before each item to add them all together.On Tuesday, November 19, 2002, at 03:42 PM, Kalin Mintchev wrote:> > On Monday, November 18, 2002, at 11:18 PM, Eric wrote: > >> Dear Sturat: >> >> I changed to: >> >> [Orderfile cart=[cart]] >> >> [Math Show=F]BW=0[lineitems]+([lookup >> db=admin/products.db&lookinfield=SKU&value=[url][sku][/ >> url]&returnfield=WEIGHT]*[quantity])[/lineitems][/Math] >> >> [/Orderfile] > > put [lineitems] after the +... > >> >> and no more error message but the [BW] did not show the value when I >> call >> >> Total weight=[BW] >> >> It merely show Total weight=[BW]. It seems the calculated value >> did not store at [BW] >> >> Regards, >> >> Eric >> >> At 02:47 PM 11/19/2002 +1100, you wrote: >>> Eric >>> >>> To use the [lineitems] you must have the equation somewhere inside an >>> [orderfile]. >>> >>> If your equation works where it is just put this in the same place: >>> >>> [Math show=F]BW=0[lineitems]+([lookup >>> db=admin/products.db&lookinfield=SKU&value=[url][sku][/ >>> url]&returnfield=WEIGHT]*[quantity])[/lineitems][/Math] >>> >>> >>> What this does is store the calculated value in a Math variable, then >>> to call the Math variable .... >>> >>> Here is the total weight = [BW] >>> >>> >>> >>> >>> >>> On Tuesday, November 19, 2002, at 02:12 PM, Eric wrote: >>> >>>> Hi, >>>> >>>> I know this is easy but somehow I am brain dead. >>>> >>>> I have the following calculation and it gives the correct value >>>> >>>> [math]0[lineitems]+[lookup >>>> db=admin/products.db&lookinfield=SKU&value=[url][sku][/ >>>> url]&returnfield=WEIGHT]*[quantity][/lineitems][/math] >>>> >>>> I wish to store the results in a field (to be called BW) so that I >>>> can >>>> use this field to display the calculated data and for further >>>> calculation. >>>> >>>> I use >>>> >>>> [BW]=[math]0[lineitems]+[lookup >>>> db=admin/products.db&lookinfield=SKU&value=[url][sku][/ >>>> url]&returnfield=WEIGHT]*[quantity][/lineitems][/math] >>>> >>>> But it did not work. >>>> >>>> Can someone help?? >>>> >>>> >>>> Stuart suggested to use the following, >>>> >>>> >>>> >>>> [Orderfile file=file] >>>> [Math show=F]BW=0[lineitems]+([lookup >>>> db=admin/products.db&lookinfield=SKU&value=[url][sku][/ >>>> url]&returnfield=WEIGHT]*[quantity])[/lineitems][/Math] >>>> [/OrderFile] >>>> >>>> Then when you need the value call the Math variable .... >>>> >>>> Here is the total weight = [BW] >>>> >>>> >>>> >>>> but it did not work and gives the following error message: >>>> >>>> Error: Can't open order file. Ignoring [OrderFile] context >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> ------------------------------------------------------------- >>>> This message is sent to you because you are subscribed to >>>> the mailing list . >>>> To unsubscribe, E-mail to: >>>> To switch to the DIGEST mode, E-mail to >>>> >>>> Web Archive of this list is at: http://search.smithmicro.com/ >>>> >>> Regards >>> >>> Stuart Tremain >>> idfk web developments >>> 114a/40 yeo street neutral bay 2089 australia >>> t +612 9908 2134 >>> f +612 9908 4837 >>> >>> >>> >>> ------------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> To switch to the DIGEST mode, E-mail to >>> >>> Web Archive of this list is at: http://search.smithmicro.com/ >>> >>> -- >>> This message has been scanned for viruses and >>> dangerous content by MailScanner, and is >>> believed to be clean. >>> ow3 >> >> >> >> ------------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to >> >> Web Archive of this list is at: http://search.smithmicro.com/ >> > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://search.smithmicro.com/ > > RegardsStuart Tremain idfk web developments 114a/40 yeo street neutral bay 2089 australia t +612 9908 2134 f +612 9908 4837------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Help on how to store calculated value (Eric 2002)
  2. Re: Help on how to store calculated value (Brian Fries 2002)
  3. Re: Help on how to store calculated value (Kalin Mintchev 2002)
  4. Re: Help on how to store calculated value (Kalin Mintchev 2002)
  5. Re: Help on how to store calculated value (Stuart Tremain 2002)
  6. Re: Help on how to store calculated value (Stuart Tremain 2002)
  7. Re: Help on how to store calculated value (Kalin Mintchev 2002)
  8. Re: Help on how to store calculated value (Eric 2002)
  9. Re: Help on how to store calculated value (Donovan Brooke 2002)
  10. Re: Help on how to store calculated value (Stuart Tremain 2002)
  11. Help on how to store calculated value (Eric 2002)
putting [lineitems] after the + will not work as you need a + after/before each item to add them all together.On Tuesday, November 19, 2002, at 03:42 PM, Kalin Mintchev wrote:> > On Monday, November 18, 2002, at 11:18 PM, Eric wrote: > >> Dear Sturat: >> >> I changed to: >> >> [Orderfile cart=[cart]] >> >> [Math Show=F]BW=0[lineitems]+([lookup >> db=admin/products.db&lookinfield=SKU&value=[url][sku][/ >> url]&returnfield=WEIGHT]*[quantity])[/lineitems][/Math] >> >> [/Orderfile] > > put [lineitems] after the +... > >> >> and no more error message but the [BW] did not show the value when I >> call >> >> Total weight=[BW] >> >> It merely show Total weight=[BW]. It seems the calculated value >> did not store at [BW] >> >> Regards, >> >> Eric >> >> At 02:47 PM 11/19/2002 +1100, you wrote: >>> Eric >>> >>> To use the [lineitems] you must have the equation somewhere inside an >>> [orderfile]. >>> >>> If your equation works where it is just put this in the same place: >>> >>> [Math show=F]BW=0[lineitems]+([lookup >>> db=admin/products.db&lookinfield=SKU&value=[url][sku][/ >>> url]&returnfield=WEIGHT]*[quantity])[/lineitems][/Math] >>> >>> >>> What this does is store the calculated value in a Math variable, then >>> to call the Math variable .... >>> >>> Here is the total weight = [BW] >>> >>> >>> >>> >>> >>> On Tuesday, November 19, 2002, at 02:12 PM, Eric wrote: >>> >>>> Hi, >>>> >>>> I know this is easy but somehow I am brain dead. >>>> >>>> I have the following calculation and it gives the correct value >>>> >>>> [math]0[lineitems]+[lookup >>>> db=admin/products.db&lookinfield=SKU&value=[url][sku][/ >>>> url]&returnfield=WEIGHT]*[quantity][/lineitems][/math] >>>> >>>> I wish to store the results in a field (to be called BW) so that I >>>> can >>>> use this field to display the calculated data and for further >>>> calculation. >>>> >>>> I use >>>> >>>> [BW]=[math]0[lineitems]+[lookup >>>> db=admin/products.db&lookinfield=SKU&value=[url][sku][/ >>>> url]&returnfield=WEIGHT]*[quantity][/lineitems][/math] >>>> >>>> But it did not work. >>>> >>>> Can someone help?? >>>> >>>> >>>> Stuart suggested to use the following, >>>> >>>> >>>> >>>> [Orderfile file=file] >>>> [Math show=F]BW=0[lineitems]+([lookup >>>> db=admin/products.db&lookinfield=SKU&value=[url][sku][/ >>>> url]&returnfield=WEIGHT]*[quantity])[/lineitems][/Math] >>>> [/OrderFile] >>>> >>>> Then when you need the value call the Math variable .... >>>> >>>> Here is the total weight = [BW] >>>> >>>> >>>> >>>> but it did not work and gives the following error message: >>>> >>>> Error: Can't open order file. Ignoring [orderfile] context >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> ------------------------------------------------------------- >>>> This message is sent to you because you are subscribed to >>>> the mailing list . >>>> To unsubscribe, E-mail to: >>>> To switch to the DIGEST mode, E-mail to >>>> >>>> Web Archive of this list is at: http://search.smithmicro.com/ >>>> >>> Regards >>> >>> Stuart Tremain >>> idfk web developments >>> 114a/40 yeo street neutral bay 2089 australia >>> t +612 9908 2134 >>> f +612 9908 4837 >>> >>> >>> >>> ------------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> To switch to the DIGEST mode, E-mail to >>> >>> Web Archive of this list is at: http://search.smithmicro.com/ >>> >>> -- >>> This message has been scanned for viruses and >>> dangerous content by MailScanner, and is >>> believed to be clean. >>> ow3 >> >> >> >> ------------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to >> >> Web Archive of this list is at: http://search.smithmicro.com/ >> > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://search.smithmicro.com/ > > RegardsStuart Tremain idfk web developments 114a/40 yeo street neutral bay 2089 australia t +612 9908 2134 f +612 9908 4837------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Stuart Tremain

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:

MySQL & WebDNA on Windows (2006) Return records from another (1997) Re:listfiles-looking for slick solution (1997) Why isn't this working (1999) [WebDNA] Comparing fields in a search (2010) Summary search -- speed (1997) Possible Bug in 2.0b15.acgi (1997) Problem (1997) WebDNA Solutions --> Date format suggestions (1998) Multiple Stores and WebCatalog Prefs (1997) redirect not passing vars (2004) [include ...] behavior (1997) Attn: Bug in GeneralStore example b15 (1997) [SearchString] problem with [search] context (1997) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) [protect admin] (1997) [item] appears after 'remove last item' ... (1997) WebCatalog Mac 2.1b3 (1997) Dates - Search and Sorting (1999) Auto Unsubscribe (2000)