Re: Price and Formula.db

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 45517
interpreted = N
texte = Nevermind, just noticed your parenthesis...GK > Also, you're doing a lookup for the same value twice and adding them > together. Not related to the problem, but wouldn't it be less processor > intensive if you just did the lookup once and *2 ? > > GK > > > > > >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? > > > > 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)
Nevermind, just noticed your parenthesis...GK > Also, you're doing a lookup for the same value twice and adding them > together. Not related to the problem, but wouldn't it be less processor > intensive if you just did the lookup once and *2 ? > > GK > > > > > >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? > > > > 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/ Gary Krockover

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:

Merging databases (1997) FAX orders (1996) Comments in db? (1997) Another pair of eyes?? (2006) Emailer Set Up (1997) Error:Too many nested [xxx] contexts (1997) ReadDateFormat bug in 3.0.1 (1998) Maybe off topic but how to charge (1997) RE: textA and Title? (1997) Emailer (WebCat2) (1997) PROBLEM (1997) Sub Totals (2000) FEATURE REQUEST: Auto Resizing of images (2002) eMailer replacement? (1998) Guestbook (2000) Big Databases (1997) WebCat2 Append problem (B14Macacgi) (1997) Re:[ShowIf] and empty fields (1997) [OT] Unix (2004) WebCat2b12 Mac.acgi--[searchstring] bug (1997)