Re: Price and Formula.db

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 45567
interpreted = N
texte = Glenn, glad you got it to work.I see you used TextD... This is still not really confirming my question. Can SOMEONE chime in here?,... Can a variable be passed into a formulas.db other than the orderfile/lineitems and internal webcat variables?thanks, Donovan Glenn Busbin wrote:> [snip] > This works: > Name Formula > Price [Math][lookup db=Products.db&lookinfield=SKU&value=[URL][SKU][/URL]&returnfield=Price]+([lookup db=Products.db&lookinfield=SKU&value=[URL][SKU][/URL]&returnfield=Price]*[lookup db=Woods.db&lookinfield=Woods&value=[URL][TextD][/URL]&returnfield=ExtraCost])[/Math][snip] -- ------------------------------------------------------------------------ ------------------------------------------------------------------------<><> Donovan Brooke <><>->ï ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------------------------------- 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: [SMSI]Re: Price and Formula.db (Donovan 2002)
  2. Re: [SMSI]Re: Price and Formula.db (Scott Anderson 2002)
  3. [SMSI]Re: Price and Formula.db (Donovan 2002)
  4. Re: Price and Formula.db (John Peacock 2002)
  5. Re: Price and Formula.db (Donovan 2002)
  6. Re: Price and Formula.db (Glenn Busbin 2002)
  7. Re: Price and Formula.db (Donovan Brooke 2002)
  8. Re: Price and Formula.db (Gary Krockover 2002)
  9. Re: Price and Formula.db (Gary Krockover 2002)
  10. Re: Price and Formula.db (Gary Krockover 2002)
  11. Re: Price and Formula.db (Glenn Busbin 2002)
  12. Re: Price and Formula.db (Donovan Brooke 2002)
  13. Re: Price and Formula.db (Stuart Tremain 2002)
  14. Re: Price and Formula.db (Arturo Vargas 2002)
  15. Re: Price and Formula.db (Andrew Simpson 2002)
  16. Re: Price and Formula.db (Glenn Busbin 2002)
  17. Re: Price and Formula.db (Gary Krockover 2002)
  18. Re: Price and Formula.db (Donovan 2002)
  19. Re: Price and Formula.db (Glenn Busbin 2002)
  20. Re: Price and Formula.db (Donovan 2002)
  21. Re: Price and Formula.db (Andrew Simpson 2002)
  22. Re: Price and Formula.db (Glenn Busbin 2002)
  23. Re: Price and Formula.db (Donovan 2002)
  24. Re: Price and Formula.db (Andrew Simpson 2002)
  25. Re: Price and Formula.db (Andrew Simpson 2002)
  26. Re: Price and Formula.db (Glenn Busbin 2002)
  27. Re: Price and Formula.db (Andrew Simpson 2002)
  28. Price and Formula.db (Glenn Busbin 2002)
Glenn, glad you got it to work.I see you used TextD... This is still not really confirming my question. Can SOMEONE chime in here?,... Can a variable be passed into a formulas.db other than the orderfile/lineitems and internal webcat variables?thanks, Donovan Glenn Busbin wrote:> [snip] > This works: > Name Formula > Price [math][lookup db=Products.db&lookinfield=SKU&value=[url][SKU][/URL]&returnfield=Price]+([lookup db=Products.db&lookinfield=SKU&value=[url][SKU][/URL]&returnfield=Price]*[lookup db=Woods.db&lookinfield=Woods&value=[url][TextD][/URL]&returnfield=ExtraCost])[/Math][snip] -- ------------------------------------------------------------------------ ------------------------------------------------------------------------<><> Donovan Brooke <><>->ï ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------------------------------- 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/ Donovan

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 - [format thousands] (1997) Templates for Customer Database? (1997) DNS Lookup (2000) Can't use old cart file (was One more try) (1997) WC TableGrinder (1997) Major Security Hole (1998) [ShowNext] (1997) Search or delete (or date or time) has bugs ... (1998) E-mail Attachments (1997) Orders to FMPro (2005) WebCat2: Items xx to xx shown, etc. (1997) More WebMerch<->MacAuthoriz (1997) What is WebDNA (1997) WHY SO MANY DUPLICATES? (1999) Subtotal Taxabletotal Grandtotal **CART** (2005) Sendmail - Pick Mail Server (2004) RE: Jimmy Houssen (1998) Re:Subcription Sales w/WebCatalog (1999) Searching for ALL / empty form field (1997) snicker, snicker (1997)