Re: Price written to db as scientific notation???

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 24832
interpreted = N
texte = Actually I tracked down the problem to having this in Formulas.dbName Formula price [math][price]*[discount][/math]Instead of the correctName 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 > I don't know Will, but my cart numbers were getting into scientific notation when > I > initailly set them inside a [math] context... maybe this is a clue. > -John > > Will Starck wrote: > > > Recently all my price variables are showing up in the shopping carts > > written in scientific notation. Does this mean my catalog.db is > > corrupted somehow??? > >------------------------------------------------------------- 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)
Actually I tracked down the problem to having this in formulas.dbName Formula price [math][price]*[discount][/math]Instead of the correctName 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 > I don't know Will, but my cart numbers were getting into scientific notation when > I > initailly set them inside a [math] context... maybe this is a clue. > -John > > Will Starck wrote: > > > Recently all my price variables are showing up in the shopping carts > > written in scientific notation. Does this mean my catalog.db is > > corrupted somehow??? > >------------------------------------------------------------- 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 Will Starck

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:

Text data with spaces in them... (1997) Search group and ww (2003) Calculating a total (2000) Showing Results Alphabetically in Columns (top to bottom) (2002) DNABill Screen Shots (2003) First postarg not taking in $Commands (1997) eq (2000) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) WebCatalog/Mac 2.1b2 - PIXO (1997) re-sorting founditems (2002) Re:E-Mailer (WebCatb15acgiMac) (1997) Summing fields (1997) docs for WebCatalog2 (1997) WebCatalog for Postcards ? (1997) [searchString] (1997) Everyone: List Traffic (was [include ...] behavior) (1997) PIXO support (1997) WebDNA-Talk (2006) [Webcat 2]Next (1997) Summing fields (1997)