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 Formulaprice [math][price]*[discount][/math]Instead of the correctName Formulaprice [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:
Actually I tracked down the problem to having this in formulas.dbName Formulaprice [math][price]*[discount][/math]Instead of the correctName Formulaprice [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:
[SearchString] usage (1997)
WebDNA Solutions ... sorry! (1997)
WebCatalog Upgrade Pricing? (1997)
RE: PDF (1999)
Enterprise Server (1998)
Protect vs Authenicate (1997)
suffix mapping for NT? (1997)
Error, 101 a DNS problem ? (1997)
Error:Too many nested [xxx] contexts (1997)
Summary search -- speed (1997)
[WebDNA] RE: webdna right click protect (2009)
PayPal WebMerchant Templates (2006)
GoLive CyberStudio 1.0.1 (1997)
Mime Headers for Mail (1998)
add to cart within a page? (1997)
show all problem (1997)
Quick Replace Question (2003)
Running 2 two WebCatalog.acgi's (1996)
with Link i need to (1997)
emailer settings and control questions (1997)