Re: formula???

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 34781
interpreted = N
texte = 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/ 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)
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/ Glenn Busbin

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:

WebCat2: Master Counter snippet (1997) POP Mail Server Reseting (1998) Fun with dates (1997) Large Database (2000) Using Applescript to process WebCatalog functions (1998) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) frames & carts (1997) credit card - Revised (1997) Million product store (2003) Grep Master Needed (2003) unsubscribe (2000) Dates - Search and Sorting (1999) Integration with SQL (1997) Mime Headers for Mail (1998) [dos] command (1997) Robots fill event log (1997) Re1000001: Setting up shop (1997) WebCat2 - Getting to the browser's username/password data (1997) UK credit card info follow-up (1997) RE: [WebDNA] XML vars from Flash (2009)