Re: LOOKUP and Math operations

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 38478
interpreted = N
texte = Dont store the Euro value with a ,, use a . instead:-)Sincerely, Nitai AventaggiatoOn 7.9.2001 12:35, Paolo Coppo wrote:> in my catalog.db I have a field called EURO; sample value: 123,45 > > [LOOKUP > db=db/catalog.db&value=[sku]&lookInField=SKU&returnField=EURO¬Found=0] > > this returns the right value, let's say 123,45 > > the problem is that I cannot *use* this value; > if I do: > > [MATH SHOW=T]temp=[LOOKUP > db=db/catalog.db&value=[sku]&lookInField=SKU&returnField=EURO¬Found=0][/MAT > H] > > I get an absolutely WRONG (integer) number; > > All I need is to pull a number with 2 decimals out of a db and then > do some calculations with it (eg quantity*value...). BTW, all > european wcat webstores will be forced to do that as the euro is > coming... > > Mac G4 / Web* 4.4 / WCat PI 4.0.2 rc1a > > TIA > > -- > blo-- We make tools to energize your business Content Management & eBusiness SystemsComputerOil GmbH http://computeroil.com Hauptstrasse 12 info@computeroil.com 8252 Schlatt/Switzerland Tel: +41 (0)52 654 15 55 ------------------------------------------------------------- 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: LOOKUP and Math operations (Paolo Coppo 2001)
  2. Re: LOOKUP and Math operations (Nitai @ ComputerOil 2001)
  3. LOOKUP and Math operations (Paolo Coppo 2001)
Dont store the Euro value with a ,, use a . instead:-)Sincerely, Nitai AventaggiatoOn 7.9.2001 12:35, Paolo Coppo wrote:> in my catalog.db I have a field called EURO; sample value: 123,45 > > [LOOKUP > db=db/catalog.db&value=[sku]&lookInField=SKU&returnField=EURO¬Found=0] > > this returns the right value, let's say 123,45 > > the problem is that I cannot *use* this value; > if I do: > > [MATH SHOW=T]temp=[LOOKUP > db=db/catalog.db&value=[sku]&lookInField=SKU&returnField=EURO¬Found=0][/MAT > H] > > I get an absolutely WRONG (integer) number; > > All I need is to pull a number with 2 decimals out of a db and then > do some calculations with it (eg quantity*value...). BTW, all > european wcat webstores will be forced to do that as the euro is > coming... > > Mac G4 / Web* 4.4 / WCat PI 4.0.2 rc1a > > TIA > > -- > blo-- We make tools to energize your business Content Management & eBusiness SystemsComputerOil GmbH http://computeroil.com Hauptstrasse 12 info@computeroil.com 8252 Schlatt/Switzerland Tel: +41 (0)52 654 15 55 ------------------------------------------------------------- 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/ Nitai @ ComputerOil

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:

problems with WebCat-Plugin (1997) IIS4b2 and WebCatalog b19 (1997) Sandboxes (2004) Emailer setup (1997) Multiple security dbs (1997) Re:What file? (1997) Using [showif] within [lineitems] [code fragment] (2000) Running _every_ page through WebCat ? (1997) Not reading code (1997) carriage returns in data (1997) 5.0 Pricing (2003) [WebDNA] Successful, working WebDNA7/CentOS install? (2013) read and write you own cookies with webcat (1997) opps... rules for .tpl only in certain domains... (2000) date stamp (2003) Enhanced Master Counter? (1997) Multiple Passwords (1997) [WebDNA] multi-langauage sites in current versions of webdna? (2010) Way Off Topic (2003) WebCat and tracking click through's (2001)