Re: Help on how to store calculated value

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 45432
interpreted = N
texte = Eric -If your initial calculation is indeed giving you the right calculated value, then the code for it is fine and you just need to get the result assigned to a math variable. Your math syntax, including the [lineitems]+[lookup... looks fine to me, as long as you are within an orderfile context.You may very well be within an IMPLIED orderfile context even if there is no [orderfile] tag on your page - WebDNA automatically invokes an orderfile context around a page when certain parameters are passed in.A simplified syntax for setting a math variable is:[math show=F]var=1+2[/math]Anywhere after that, specifying [var] will return 3.So, use:[math show=F]BW=0[lineitems]+[lookup db=admin/products.db&lookinfield=SKU&value=[url][sku][/url]&returnfield=WEIGHT]*[quantity][/lineitems][/math]then [BW] will hold your calculated value.You DO NOT need to add [orderfile cart=[cart]] to your page if the calculation is already working - this may very well foul things up by creating a new empty order file.- brianAt 9:12 PM -0600 11/18/02, 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/ ------------------------------------------------------------- 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:

    
  1. Re: Help on how to store calculated value (Eric 2002)
  2. Re: Help on how to store calculated value (Brian Fries 2002)
  3. Re: Help on how to store calculated value (Kalin Mintchev 2002)
  4. Re: Help on how to store calculated value (Kalin Mintchev 2002)
  5. Re: Help on how to store calculated value (Stuart Tremain 2002)
  6. Re: Help on how to store calculated value (Stuart Tremain 2002)
  7. Re: Help on how to store calculated value (Kalin Mintchev 2002)
  8. Re: Help on how to store calculated value (Eric 2002)
  9. Re: Help on how to store calculated value (Donovan Brooke 2002)
  10. Re: Help on how to store calculated value (Stuart Tremain 2002)
  11. Help on how to store calculated value (Eric 2002)
Eric -If your initial calculation is indeed giving you the right calculated value, then the code for it is fine and you just need to get the result assigned to a math variable. Your math syntax, including the [lineitems]+[lookup... looks fine to me, as long as you are within an orderfile context.You may very well be within an IMPLIED orderfile context even if there is no [orderfile] tag on your page - WebDNA automatically invokes an orderfile context around a page when certain parameters are passed in.A simplified syntax for setting a math variable is:[math show=F]var=1+2[/math]Anywhere after that, specifying [var] will return 3.So, use:[math show=F]BW=0[lineitems]+[lookup db=admin/products.db&lookinfield=SKU&value=[url][sku][/url]&returnfield=WEIGHT]*[quantity][/lineitems][/math]then [BW] will hold your calculated value.You DO NOT need to add [orderfile cart=[cart]] to your page if the calculation is already working - this may very well foul things up by creating a new empty order file.- brianAt 9:12 PM -0600 11/18/02, 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/ ------------------------------------------------------------- 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/ Brian Fries

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:

t or f (1997) webstar/webcat monitoring aides? (1999) [isfile] ? (1997) Undeliverable Mail (1997) Need help with [cart] (2000) drop down selection list for a search (1998) Another problem with CyberCash and WebMerchant (2000) [isfile] ? (1997) Path of Events (1999) syntax question, not in online refernce (1997) Signal Raised (1997) Error Lob.db records error message not name (1997) The EMailer and the Blank menu bar? (1999) Diners Club card problems (1999) Hello world ... (2002) Multiple catalog databases and showcart (1997) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) [WebDNA] Fun With WebDNA (2013) Auth.net and SIM (2003) Apache on windows and WebDNA (2004)