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 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:

    
  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)
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 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:

LOOP and IF statements (1997) again (1998) Limiting user access to .tmpl files (1997) WebCat2b12--[searchstring] bug (1997) Flash loadVariables (2003) I'm new be kind (1997) Merging databases (1997) AppleScript: Tell application:app location? (1998) WebCat2b12 - nesting [tags] (1997) WebCat editing, SiteGuard & SiteEdit (1997) For you Unix gurus [OT] (2002) Generating Report Totals (1997) Updating a database once per day - An example (1998) [shownext max (1997) Preventing code execution (2003) Stopping bad HTML propagation ? (1997) Location of Webcat site in folder hierarchy (1997) [include file=filename.inc&strip=t] (2002) emails sent twice (2001) WebCatalog 2.0 & WebDNA docs in HTML ... (1997)