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:

OFF-TOPIC: Check www.godaddy.com for me ... (2003) search problem (2002) WebCat2b15MacPlugin - showing [math] (1997) OT- AS/400 and Macs (2003) New NT betas available (1997) BadSuffix with 2.1b3 cgi (1997) Convert Chars Q (2000) Problems with [Applescript] (1997) RE: Cart Template (1997) WCS Newbie question (1997) carriage returns in data (1997) Kaaaaahhhhhhhnnnnnnn! (1997) Mac Authorize (1999) emailer (1997) Using Cookie for client specific info? (1997) &max= (2003) [referrer] tag (1997) counting characters and/or words (1997) Include a big block of text (1997) Support ?? (1997)