Re: Help on how to store calculated value
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 45424
interpreted = N
texte = EricTo 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/ > > RegardsStuart 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/
Associated Messages, from the most recent to the oldest:
EricTo 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/ > > RegardsStuart 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/
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:
blank page from template (1997)
Database Updates (1997)
[WriteFile] problems (1997)
BUG in [showif] using ^ (contains) (1997)
Webcatalog server support (1997)
wild question (1998)
Search/sort in URL Was: GuestBook example (1997)
WebDNA tags in WebMerchant email templates ... (1997)
encryption madness (2003)
Giving out error pages (1997)
Zip Code Search (2000)
[WebDNA] Help with iTools 9/WebDNA setup MacTel (2009)
WebCat2b15MacPlugin - [protect] (1997)
Quit revisited (1997)
Re:affiliate marketing program (1998)
[returnraw] and form variables (1998)
Retrieve deleted files (2001)
Help with nested search (1998)
redirect with frames (1997)
pictures / referrer etc. (1998)