Re: Help on how to store calculated value
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 45429
interpreted = N
texte = EricPlease post all your code for the page so we can see what is going wrong:)On Tuesday, November 19, 2002, at 03: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]>> 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/>>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:
EricPlease post all your code for the page so we can see what is going wrong:)On Tuesday, November 19, 2002, at 03: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]>> 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/>>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:
Speed Test Results Dell 2650 Xeon 2.4ghz (2002)
autocommit problem (1998)
Major Security Hole (1998)
Progress !! WAS: Trouble with formula.db (1997)
[include ...] behavior (1997)
Email troubles (2005)
converchars in sendmail context.... (2004)
success - serial numbers and webmerch (1997)
[OT] Invoking a MP3 Download (2004)
Re[2]: 2nd WebCatalog2 Feature Request (1996)
text size limitation (1997)
Don't tick me off :) [elaspedtime] (1997)
[OT] Mom's gift (2006)
[WebDNA] Version 8 (2014)
How to archive....? (1998)
[WebDNA] WebDNA DOCS (2017)
Practice runs ? (1997)
WebCat b15 Mac plug-in (1997)
Where's Cart Created ? (1997)
Search group and ww (2003)