LOOKUP and Math operations

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 38477
interpreted = N
texte = 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,45the 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][/MATH]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 rc1aTIA-- blo -- -- blo :->------------------------------------------------------------- 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)
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,45the 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][/MATH]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 rc1aTIA-- blo -- -- blo :->------------------------------------------------------------- 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/ Paolo Coppo

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:

default value from Lookup (was Grant, please help me) (1997) New Weird Behavior (bug report) (2000) WCS Newbie question (1997) background (2001) WC1.6 to WC2 date formatting (1997) unique ascending numbers (2003) OT: Limit on # of Pulldown entries (1997) popups, netscape vs explorer (1997) emailer (1997) WebDNA Partner edition .. (2002) WebCat2 - Getting to the browser's username/password data (1997) RE: ANother SHOWIF problem (1997) Problems with large number of items in a cart. (1998) W* 3.x & WebCat + WebMerchant (1998) [append] vs. [appendfile] delta + question? (1997) Need a better [elapsedtime] (2000) Another OS 10.3 Upgrade issue (2003) shownext not showing next...still r2 (1997) For you Unix gurus [OT] (2002) DreamWeaver extension (2000)