Re: Price and Formula.db
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 45499
interpreted = N
texte = Not per the online docs (example from File Formats - Formulas):[math][showif [username]=GRANT]0.0*[/showif][lookup db=catalog.txt&lookInField=sku&value=[sku]&returnField=price][/math]One test that Glenn might try is putting a ¬found=9999 for one of the lookups and then a ¬found=8888 for the other and see if those values come through as the price. If so, then you know the lookup isn't finding what it should (though Glenn reports it does outside of the formulas.db).GK | | | Glenn Busbin wrote: | | > >are you sure that the variable you are using in the lookup is avaiable in | > >the scope of the formulas database? | > > | > | > I'm sure the same formula used in the Formulas.db is able to access the variable when copied and pasted into a template. | > | > I can also hard code the variable into the Formulas.db and get the correct price in the shopping cart, but hard coding defeats the purpose of the lookup. | > | > Why it won't work with a lookup is beyond me. This is getting to be more than frustrating. | | Glenn, did you do the test that I stated? In a site that I built I had to learn the formulas.db inside and out including multiple nested includes of code. | I re-looked at them and I didn't use any outside vars. I either used [orderfile] vars or set newones within my includes. This leads me to believe | that I forgot that you CANT pass non-orderfile variables into the formulas.db. | | Can anyone confirm or deny? | | If it is confirmed.. maybe you can setheader your needed data to a header1-40 and use that? | | At any rate, if you want to test it only hard code your [option] var and see if it works. If it does then your problem | is that you are not getting that variable passed. | | Donovan | | > | > | > Glenn | > | | -- | ------------------------------------------------------------------------ | | ------------------------------------------------------------------------ | | <><> 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:
Not per the online docs (example from File Formats - Formulas):[math][showif [username]=GRANT]0.0*[/showif][lookup db=catalog.txt&lookInField=sku&value=[sku]&returnField=price][/math]One test that Glenn might try is putting a ¬found=9999 for one of the lookups and then a ¬found=8888 for the other and see if those values come through as the price. If so, then you know the lookup isn't finding what it should (though Glenn reports it does outside of the formulas.db).GK | | | Glenn Busbin wrote: | | > >are you sure that the variable you are using in the lookup is avaiable in | > >the scope of the formulas database? | > > | > | > I'm sure the same formula used in the formulas.db is able to access the variable when copied and pasted into a template. | > | > I can also hard code the variable into the formulas.db and get the correct price in the shopping cart, but hard coding defeats the purpose of the lookup. | > | > Why it won't work with a lookup is beyond me. This is getting to be more than frustrating. | | Glenn, did you do the test that I stated? In a site that I built I had to learn the formulas.db inside and out including multiple nested includes of code. | I re-looked at them and I didn't use any outside vars. I either used [orderfile] vars or set newones within my includes. This leads me to believe | that I forgot that you CANT pass non-orderfile variables into the formulas.db. | | Can anyone confirm or deny? | | If it is confirmed.. maybe you can setheader your needed data to a header1-40 and use that? | | At any rate, if you want to test it only hard code your [option] var and see if it works. If it does then your problem | is that you are not getting that variable passed. | | Donovan | | > | > | > Glenn | > | | -- | ------------------------------------------------------------------------ | | ------------------------------------------------------------------------ | | <><> 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/
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:
WebDNA Solutions ... sorry! (1997)
A little help on e-mail (HELP!!! :-) ) (1998)
2.1b3 --> way slow (1997)
Moment of Thanks (1997)
New Beta Documentation (1997)
Bug Report, maybe (1997)
[WebDNA] WebDNA 4.5.1 process DBServer.exe memory (2008)
Problem (1997)
taxrate - off by 1 cent (1997)
WebCat2b15MacPlugin - showing [math] (1997)
quit sending me mail!!!!! (1999)
Menu to select product variations (1997)
feature request-- [epoch] (2004)
Re:WebCatalog 3 for Macintosh (1998)
[ShowNext] (1997)
LOOP and IF statements (1997)
Banners and sort of random display (1997)
suggestions for a good text editor on windows? (2005)
[CART] (1997)
W* 4.2 / WebCat (TPro) 3.0.5b / OS 8.5.1 / BW G3 (2000)