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:

    
  1. Re: Price written to db as scientific notation??? (John Butler 1999)
  2. Re: Price written to db as scientific notation??? (John Butler 1999)
  3. Re: Price written to db as scientific notation??? (Will Starck 1999)
  4. Price written to db as scientific notation??? (Will Starck 1999)
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)