Re: Help on how to store calculated value

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 45430
interpreted = N
texte = 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][/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/ 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)
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][/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/ 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:

[subtotal] and others (1997) HTML encoding in URLs (1997) Help!!!! (1997) Make sure I understand this??? (1997) Fw: virus alert; Jdbgmgr.exe (2003) WYSIWYG HTML editor for use in browser (2001) Subtotal Not Calculated on Invoice.html (1998) RE: Price recalc based on quantity (1997) WebCatalog can't find database (1997) WebCommerce: Folder organization ? (1997) WebStar quitting since upgrading to WC4 (2000) Shopping cart not being assigned (1999) Lookup Notfound (1998) [WebDNA] [OT] economical reliable SSL certs? (2009) [Sum] function? (1997) passing search criteria (1997) Search Result refinement help (2003) WebCat for Unix?? (1997) Using Plug-In while running 1.6.1 (1997) ooops...WebCatalog [FoundItems] Problem - LONG - (1997)