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