Re: formula???
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 34788
interpreted = N
texte = I am using an add command and I think is working. I am running into some problems though, such as the subtotal not being correct in the shopping cart. Even after the page is refreshed the price and total(quantity x price) show correct. But, the subtotal doesn'tArt-----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of John Butler Sent: Monday, July 17, 2000 1:01 PM To: WebCatalog Talk Subject: Re: formula??? are you using an add command or an [addlineitem] context?Glenn Busbin wrote:> OK, but why does the following NOT work? > > Name Formula > price [math][showif [quantity]>2]0.9*[/showif][lookup > db=mydatabase.db&lookInField=sku&value=[sku]&returnField=price][/math] > > It returns only the [price] value just as I'd get with no formula. > > >I have always found formulas.db to be the least understood, yet the most > >powerful feature within WebCat. We use it constantly, because our > >primary database contains 1 record for both cloth and paper editions. I > >must look up the price in a secondary table based on the value of TextB: > > > >price [lookup db=../IMPRINT.db&lookinfield=ISBN&value=[textb] > >&returnfield=USPrice] > > > >That is a tab between price and the formula. This works like magic. > > > > ------------------------------------------------------------- > 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/ ------------------------------------------------------------- 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/ ------------------------------------------------------------- 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:
I am using an add command and I think is working. I am running into some problems though, such as the subtotal not being correct in the shopping cart. Even after the page is refreshed the price and total(quantity x price) show correct. But, the subtotal doesn'tArt-----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of John Butler Sent: Monday, July 17, 2000 1:01 PM To: WebCatalog Talk Subject: Re: formula??? are you using an add command or an [addlineitem] context?Glenn Busbin wrote:> OK, but why does the following NOT work? > > Name Formula > price [math][showif [quantity]>2]0.9*[/showif][lookup > db=mydatabase.db&lookInField=sku&value=[sku]&returnField=price][/math] > > It returns only the [price] value just as I'd get with no formula. > > >I have always found formulas.db to be the least understood, yet the most > >powerful feature within WebCat. We use it constantly, because our > >primary database contains 1 record for both cloth and paper editions. I > >must look up the price in a secondary table based on the value of TextB: > > > >price [lookup db=../IMPRINT.db&lookinfield=ISBN&value=[textb] > >&returnfield=USPrice] > > > >That is a tab between price and the formula. This works like magic. > > > > ------------------------------------------------------------- > 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/ ------------------------------------------------------------- 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/ ------------------------------------------------------------- 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/
Arturo Vargas
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:
Price Change (2000)
HTML Editors (1997)
[WebDNA] Different settings on old vs new admin pages (2010)
URGENT: NO BUG, woFIELDdata & FIELDword=ww (2002)
taxTotal, too (1997)
OT: IP addres checking (2003)
webcat- multiple selection in input field (1997)
Mime Headers for Mail (1998)
sendmail spaces (1997)
Help name our technology! (1997)
How to include weather (2000)
emailer (1997)
RE: PIXO support (1997)
Apache 2 (2002)
Ok here is a question? (1997)
quantity minimum problem (1997)
Protect and Serve (1999)
CyberCash problem in OS9/4.5 -> OSX/5.1 transition (2003)
More on the email templates (1997)
Re:Change WebDNA-Talk Mail due to no digest for 1wk (1997)