Re: Help on how to store calculated value
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 45426
interpreted = N
texte = 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 callTotal weight=[BW]It merely show Total weight=[BW]. It seems the calculated value did not store at [BW]Regards,EricAt 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/
Associated Messages, from the most recent to the oldest:
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 callTotal weight=[BW]It merely show Total weight=[BW]. It seems the calculated value did not store at [BW]Regards,EricAt 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/
Eric
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:
Unexpected error (1997)
Emailer port change (1997)
ShipCost and TaxRate problems (1998)
remotely add + sign (1997)
Problems with webcat 2.01 for NT (1997)
WebDNA hosting? ... (2004)
looping table rows (1999)
Date Time Oddness (1999)
find with exceptions (1997)
PSC recommends what date format yr 2000??? (1997)
Price + Texte (1999)
autocommit problem (1998)
[ShowNext] (1997)
reversing the effects of [url] (1997)
SetHeader not Working (2006)
WebDNA 6 with iTools 8.2 (2006)
Robert Minor duplicate mail (1997)
WebCat2: Formulas.db question (1997)
Languages (1997)
Uh...can someone help me out with the b10? (1997)