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:
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
$Quit, $CloseDatabase corrections (1997)
why won't this TCPConnect/Send work? (2004)
why am I getting an authenticate dialog with no [protect]? (2000)
NT considerations (1997)
setting line item numbers (1998)
[OT] Might be of interest... (2006)
proper way to check if a container is empty? (2000)
Re:2nd WebCatalog2 Feature Request (1996)
WebMerchant when CC network is down (1998)
problem with applets embedded in tpl files (1997)
Help name our technology! (1997)
Sku numbers (1997)
php vs WebCatalog (2000)
Virus Alert: FBI Finds 911 Virus Wiping Out Hard Drives Today (2000)
PCS Frames (1997)
WebCatalog for guestbook ? (1997)
IIS4/IIS3 and WebCatalog registry settings (1998)
WC2b15 - [HTMLx]...[/HTMLx] problems SOLVED! (1997)
Search Engine questions ... (2002)