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 businessContent Management & eBusiness SystemsComputerOil GmbH http://computeroil.comHauptstrasse 12 info@computeroil.com8252 Schlatt/SwitzerlandTel: +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:
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 businessContent Management & eBusiness SystemsComputerOil GmbH http://computeroil.comHauptstrasse 12 info@computeroil.com8252 Schlatt/SwitzerlandTel: +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)