Re: Price and Formula.db

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 45520
interpreted = N
texte = Glenn Busbin wrote:>>Glenn, I understand your frustration.. However, I am under the opinion the formulas.db works >>just fine... but I will agree that the documentation lacks on details and scenerios. You still haven't >>responded on my test I offered to you. See below. >> >> >> > > >Isn't this what you're talking about? > That test shows that the formulas.db is working but... no, the Idea is to find the exact thing that isn't working. I suspect it could be the [woods] var. So, take this var out and hard code it like so: (excluding cr's of course)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=****A_HARD_CODED_VALUE****&returnfield=ExtraCost])[/Math] Taxable F UNITSHIPCOST 0.00 SHIPCOST 0.00 TAXRATE 0.00 This will tell you if the rest of your code works. However, also take note of what Gary mentioned ;-)Donovan> >Test 2- If I change the Price formula to: >[Math][lookup db=Products.db&lookinfield=SKU&value=[URL][SKU][/URL]&returnfield=Price]+10[/Math] > >it will add 10 to the price from the Products.db 100% of the time. > > > ------------------------------------------------------------- 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 Busbin wrote:>>Glenn, I understand your frustration.. However, I am under the opinion the formulas.db works >>just fine... but I will agree that the documentation lacks on details and scenerios. You still haven't >>responded on my test I offered to you. See below. >> >> >> > > >Isn't this what you're talking about? > That test shows that the formulas.db is working but... no, the Idea is to find the exact thing that isn't working. I suspect it could be the [woods] var. So, take this var out and hard code it like so: (excluding cr's of course)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=****A_HARD_CODED_VALUE****&returnfield=ExtraCost])[/Math] Taxable F UNITSHIPCOST 0.00 SHIPCOST 0.00 TAXRATE 0.00 This will tell you if the rest of your code works. However, also take note of what Gary mentioned ;-)Donovan> >Test 2- If I change the Price formula to: >[math][lookup db=Products.db&lookinfield=SKU&value=[url][SKU][/URL]&returnfield=Price]+10[/Math] > >it will add 10 to the price from the Products.db 100% of the time. > > > ------------------------------------------------------------- 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 Brooke

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:

[Sum] function? (1997) PIXO support (1997) HomePage Caution (1997) Menu to select product variations (1997) Using Cookie for client specific info? (1997) webcat 2.1 new cart fields - please explain more (1998) Extended [ConvertChars] (1997) Pithy questions on webcommerce & siteedit (1997) Problems reading files created by WC (1997) [WebDNA] WebDNA 7 on 8GB RAM server (2013) Email SMTP Error 411 (2006) multi-paragraph fields (1997) Summing fields (1997) Multi Math bug? (2000) 2.1 pricing? (1998) WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997) Narrowing NT Crashing error (2000) How to Sort Summ data ? (1997) Cannot get subtotal to work (1997) One Hour Email (2002)