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 FormulaPrice [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.00SHIPCOST 0.00TAXRATE 0.00This 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:
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 FormulaPrice [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.00SHIPCOST 0.00TAXRATE 0.00This 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)