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:
Bug Report, maybe (1997)
protect (summer holidays with wcat???) (2000)
Web Delivery Page concept (1997)
Re:quit command on NT (1997)
Search and list the titles of book (2003)
[sendmail] (2000)
Using Cookie for client specific info? (1997)
Search in 2 or more catalogs (1997)
[tcp connect] (1998)
country of origin from IPADDRESS??? (2001)
format and math on the fly (1998)
WebCat editing, SiteGuard & SiteEdit (1997)
WebCat2b15MacPlugin - showing [math] (1997)
Tax & Shipping (1997)
Nav. 4 probs with cart - Serious problem (1997)
[WebDNA] YouTube API v2.0 - OAuth 2.0 Authorization (2013)
fieldType=num (1997)
Document Contains No Data! (1997)
A multi-processor savvy WebCatalog? (1997)
math/text variable limits per page (2001)