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 2 tags (1997) Pre-flight public flag (1997) test - ignore (2008) [searchString] (1997) Multiple catalog databases and showcart (1997) FYI: virus alert (1996) [OT] test (2002) b12 cannot limit records returned and more. (1997) TCPconnect using SSL. If not WebCat, How? (1999) But with European Dates? (2006) [CART] (1997) Need relative path explanation (1997) WebDNA 5.0 Questions (2003) RAM variables (1997) Help!!!! (1999) Installation webCatalog (French speakers please help) (1998) Now you see it now you don´t (1997) calender with business days (1998) combining strings (1997) [url] link (1998)