Re: Help on how to store calculated value

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 45431
interpreted = N
texte = i think this will work... note the zero after the [/orderfile] [Math Show=F]BW=0+[!] [/!][Orderfile cart=[cart]][!] [/!][lineitems]([lookup db=admin/products.db&lookinfield=SKU&value=[url][sku][/ url]&returnfield=WEIGHT]*[quantity])+[!] [/!][/lineitems][!] [/!][/Orderfile]0[/Math] On Monday, November 18, 2002, at 11:55 PM, Kalin Mintchev wrote:> > On Monday, November 18, 2002, at 11:45 PM, Stuart Tremain wrote: > >> putting [lineitems] after the + will not work as you need a + >> after/before each item to add them all together. > > if that's the idea then the code should be: > > > > [Math Show=F]BW=0+[!]> [/!][Orderfile cart=[cart]][!] > [/!][lineitems]([lookup > db=admin/products.db&lookinfield=SKU&value=[url][sku][/ > url]&returnfield=WEIGHT]*[quantity])+[!] > [/!][/lineitems][!] > [/!][/Orderfile]0[/Math] > > or something like it... > > >> >> >> >> 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/ >>> >>> >> 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 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/ 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)
i think this will work... note the zero after the [/orderfile] [Math Show=F]BW=0+[!] [/!][Orderfile cart=[cart]][!] [/!][lineitems]([lookup db=admin/products.db&lookinfield=SKU&value=[url][sku][/ url]&returnfield=WEIGHT]*[quantity])+[!] [/!][/lineitems][!] [/!][/Orderfile]0[/Math] On Monday, November 18, 2002, at 11:55 PM, Kalin Mintchev wrote:> > On Monday, November 18, 2002, at 11:45 PM, Stuart Tremain wrote: > >> putting [lineitems] after the + will not work as you need a + >> after/before each item to add them all together. > > if that's the idea then the code should be: > > > > [Math Show=F]BW=0+[!]> [/!][Orderfile cart=[cart]][!] > [/!][lineitems]([lookup > db=admin/products.db&lookinfield=SKU&value=[url][sku][/ > url]&returnfield=WEIGHT]*[quantity])+[!] > [/!][/lineitems][!] > [/!][/Orderfile]0[/Math] > > or something like it... > > >> >> >> >> 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/ >>> >>> >> 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 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/ Kalin Mintchev

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:

WC Database Format (1997) [WriteFile] problems (1997) multiple search commands (1997) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) WebDNA-Talk Digest mode broken (1997) Running subtotal? (1998) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) Add to a field (1998) Balancing randomness (2000) no global [username] or [password] displayed ... (1997) Saving Text Areas with Orders (1997) Searching multiple Databases (1997) DB approach question (2000) Uh...can someone help me out with the b10? (1997) Database and Log file merged..... (2000) [Sum] function? (1997) encryption madness (2003) how to check for no value while using [URL] to prevent cr (1999) WebCatalog2 Feature Feedback (1996) Shownext never shows next...still (1997)