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:
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)