Re: Price written to db as scientific notation???
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 24840
interpreted = N
texte = In my case, I just had to know that one cannot intially set cart numbers inside a [math].It's a biiiiig number and so naturally gets into scientific notation.:-)Thanks-JohnWill Starck wrote:> Actually I tracked down the problem to having this in Formulas.db>> Name Formula> price [math][price]*[discount][/math]>> Instead of the correct>> Name Formula> price [math][lookup> db=catalog.db&value=[sku]&lookinfield=sku&returnfield=price]*[lookup> db=catalog.db&value=[sku]&lookinfield=sku&returnfield=discount][/math]>> Of course, in the first case math is trying to multiply the literal> characters [ p r i c e and ]> by [discount], which equals god knows what, but ends up in> scientific notation...>> Maybe this helps with your problem, no?>> Will>-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to
.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
Associated Messages, from the most recent to the oldest:
In my case, I just had to know that one cannot intially set cart numbers inside a [math].It's a biiiiig number and so naturally gets into scientific notation.:-)Thanks-JohnWill Starck wrote:> Actually I tracked down the problem to having this in formulas.db>> Name Formula> price [math][price]*[discount][/math]>> Instead of the correct>> Name Formula> price [math][lookup> db=catalog.db&value=[sku]&lookinfield=sku&returnfield=price]*[lookup> db=catalog.db&value=[sku]&lookinfield=sku&returnfield=discount][/math]>> Of course, in the first case math is trying to multiply the literal> characters [ p r i c e and ]> by [discount], which equals god knows what, but ends up in> scientific notation...>> Maybe this helps with your problem, no?>> Will>-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to .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
John Butler
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:
Upgrading (2003)
Problem (1997)
PIXO support (1997)
WebDNA HitLogger available (was Signal Raised Error) (1997)
Sort of a Dilemma! (1998)
[WriteFile] problems (1997)
Separate SSL Server (1997)
Frames and WebCat (1997)
RE: error count with $purchase (1997)
[WC 2.1.30] Stack overflow. (2000)
Everyone: List Traffic (was [include ...] behavior) (1997)
test mail (2004)
PCSDecrypt bugs still unfixed ... (2000)
Slow Server (2005)
Xserve Recommendations (2003)
OT: WebDNA and LINUX (2004)
Repeating Fields (1997)
Refresh cart# (1999)
& not allowed in db by definition? (1999)
HELP WITH DATES (1997)