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 Tremainidfk web developments114a/40 yeo street neutral bay 2089 australiat +612 9908 2134f +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:
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 Tremainidfk web developments114a/40 yeo street neutral bay 2089 australiat +612 9908 2134f +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:
How to Sort Summ data ? (1997)
Hiding HTML and page breaks (1997)
RAM variables (1997)
Payflow Pro on OSX (2003)
OT: Need some feedback, please. (2003)
Live hits (2003)
Count regular expressions in a file (2007)
Image upload (2000)
Seattle based Webcatters? (2000)
Multiple instances of database (2003)
Internet Explorer 6 Form problems (2005)
Using Plug-In while running 1.6.1 (1997)
NewCart+Search with one click ? (1997)
[DELETEFILE] via http (2003)
Live Webcasts (1999)
Sending emails (went[ot] ) (2002)
E-mail Attachments (1997)
WebCat2b12 - nesting [tags] (1997)
off topic - dna snipets (1997)
Install Webcatalog under NT4.0 and Microsoft IIS 2.0 (1997)