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:

    
  1. Re: formula??? (John Peacock 2000)
  2. Re: formula??? (John Peacock 2000)
  3. Re: formula??? (Glenn Busbin 2000)
  4. Re: formula??? (John Butler 2000)
  5. Re: formula??? (John Butler 2000)
  6. Re: formula??? (Glenn Busbin 2000)
  7. Re: formula??? (WebDNA Support 2000)
  8. Re: formula??? (Glenn Busbin 2000)
  9. Re: formula??? (Arturo Vargas 2000)
  10. Re: formula??? (WebDNA Support 2000)
  11. Re: formula??? (John Butler 2000)
  12. Re: formula??? (Glenn Busbin 2000)
  13. Re: formula??? (John Peacock 2000)
  14. Re: formula??? (Glenn Busbin 2000)
  15. Re: formula??? (John Peacock 2000)
  16. formula??? (Arturo Vargas 2000)
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:

[SearchString] usage (1997) [WebDNA] SHA-512 How To Do It (2014) Kaaaaahhhhhhhnnnnnnn! (1997) Encryption Question (2006) WebCat2b13 Command Reference Doc error (1997) [WebDNA] User - Group - permissions (2009) different show next (1997) japanese characters (1997) Cookie Problems (2000) Seeking NT Mail Server Experiences (1998) Searching multiple fields (1997) Online Docs? (1997) U&P IIS concept (1998) [moveFile] Question (1999) Upgrading old WebCat Database Files (1997) Calculating multiple shipping... (1997) Not really WebCat (1997) Banner DNA (1997) PIXO support (1997) WebCatalog seems to choke on large (2meg) html files. (1998)