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:

SSL and reg web* (1997) [UPPERCASE] (1997) PCS Frames-Default page is solution! (1997) Cart ID (1999) Country & Ship-to address & other fields ? (1997) Wrapping text (1998) Date Comparison (1998) Text variables do not show (1999) page redirect in webDNA (1997) What do the &x=5&y=8 mean? (2002) Secure Server (1997) Fun with Dates - revisited (1997) Missing from Docs [folderName] (1997) Unexpected error (1997) Some Questions (1997) deerfield/wingate server (2004) change the number format (1997) removelineitems (2000) NT version and O'reily's WebSite (1997) Suffix Mapping (1997)