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:
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)