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 detailsand> 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:
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 detailsand> 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)