Re: Looking up two prices in database?
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 12592
interpreted = N
texte = Grant,>You may need to change the [saleprice] tag in your formula to [lookup >>db=products.db&lookInField=SKU&value=[SKU]&returnField=saleprice]Tried that! No difference.Is my basic formula correct, that is, am I going at it the right way with:price
[math][showif [onsale]=T][saleprice][/showif][lookup db=products.db&lookInField=SKU&value=[SKU]&returnField=price][/math]To me the logic of this formula is this:1. I'm actually not sure why I am using the [math] context. I'm really using two conditional statements to look for the price I want. COMMENT?2. The [showif] context defines the first condition. Check to see if the onsale field has a value of T. If it does, THEN show the value of the saleprice field as instructed by the [saleprice] tag.3. If the condition is met, I would expect the formula to show the sale price in the cell where I have any [price] tag.If it isn't met, I would expect the lookup to be performed and the regular price to be displayed wherever there is a [price] tag.That brings up the next question, which is, does WebCatalog move to the [lookup] or does it stop after the [showif]?I also thought of this formula, but it doesn't seem to work either.price[math][showif [onsale]=T][lookup db=products.db&lookInField=SKU&value=[SKU]&returnField=saleprice][/showif][/math]Once again, the search is very straightfoward:Click here to see our in-house specials.The results.tmpl looks like this:[foundItems] [sku] | [media] | [Title] | [Artist] | [format .2f][price][/format] | Add to cart |
[/foundItems]Jerry
Associated Messages, from the most recent to the oldest:
Grant,>You may need to change the [saleprice] tag in your formula to [lookup >>db=products.db&lookInField=SKU&value=[SKU]&returnField=saleprice]Tried that! No difference.Is my basic formula correct, that is, am I going at it the right way with:price[math][showif [onsale]=T][saleprice][/showif][lookup db=products.db&lookInField=SKU&value=[SKU]&returnField=price][/math]To me the logic of this formula is this:1. I'm actually not sure why I am using the [math] context. I'm really using two conditional statements to look for the price I want. COMMENT?2. The [showif] context defines the first condition. Check to see if the onsale field has a value of T. If it does, THEN show the value of the saleprice field as instructed by the [saleprice] tag.3. If the condition is met, I would expect the formula to show the sale price in the cell where I have any [price] tag.If it isn't met, I would expect the lookup to be performed and the regular price to be displayed wherever there is a [price] tag.That brings up the next question, which is, does WebCatalog move to the [lookup] or does it stop after the [showif]?I also thought of this formula, but it doesn't seem to work either.price[math][showif [onsale]=T][lookup db=products.db&lookInField=SKU&value=[SKU]&returnField=saleprice][/showif][/math]Once again, the search is very straightfoward:Click [cart]&eqonsaledata=T>here to see our in-house specials.The results.tmpl looks like this:[founditems] [sku] | [media] | [Title] | [Artist] | [format .2f][price][/format] | [url][SKU][/url]&cart=[cart]>Add to cart |
[/foundItems]Jerry
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:
Size limit for tmpl editor ? (1997)
unable to launch acgi in WebCat (1997)
Case sensitivity and [showif] (1999)
Number of Open Databases (1998)
WebDNA Challenge - Was: Why WebDNA is not popular (2002)
Limit on nested [ShowIf]'s? (1997)
What abobut variables named max ??? (2000)
WC2f3 (1997)
Adding more than one item and QTY to cart (2000)
is this how [break] works? (1998)
3rd request: What are SMSI's upgrade policies? (2003)
help with duplicate records posted (1998)
how do ye do this?????? (2001)
Showif, Hideif reverse logic ? (1997)
Can't save email prefs (2003)
A dynamic database. (1997)
Almost a there but..bye bye NetCloak (1997)
New public beta available (1997)
[WriteFile] problems (1997)
Snake Bites (1997)