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:
WebCat2.0 acgi vs plugin (1997)
Date sorting (1997)
WebCatalog Hosting (1996)
Training Tapes Improved (1998)
Strange Form Occurrence on Log In Pages (2005)
FTP FOLDER PERMISSIONS (2004)
Migrating to NT (1997)
syntax question, not in online refernce (1997)
[OT] RedHat - GNOME (2004)
[WebDNA] ListMIMEHeaders (2008)
PSC recommends what date format yr 2000??? (1997)
Re:Formulas.db / Quantity Discount problem (1998)
Individual Tax on Items (1998)
where to put code (1998)
Navigator 4.01 (1997)
Using Cookie for client specific info? (1997)
WebCatalog2 for NT Beta Request (1997)
[WebDNA] [raw] tag with [interpret] question (2010)
creating a ShipCosts database (1997)
with Link i need to (1997)