Re: formula???
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 34784
interpreted = N
texte = 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/
Associated Messages, from the most recent to the oldest:
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/
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:
Sorting... stumped. (2006)
Single Link browsing (1997)
Large sites (2003)
WebCat2 Append problem (B14Macacgi) (1997)
Another question (1997)
[append] problem (1997)
Progress !! WAS: Trouble with formula.db (1997)
[WebDNA] search by range of dates (2009)
Giving out error pages (1997)
splitting up items in a cart (1999)
ReadDateFormat bug in 3.x (1998)
webcat running as www, should that be webstar for use with (2002)
Fun with Dates - finally resolved but.... (1997)
change the number format (1997)
Where is f2? (1997)
Problems appending to database (1997)
Help! WebCat2 bug (1997)
Tried installing Windows beta with no success... (2000)
[shownext] and descending order (1997)
Help! WebCat2 bug (1997)