Re: Looking up two prices in database?
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 12582
interpreted = N
texte = >1. How do I get WebCatalog to look up and display the saleprice when >onsale=T and the regular price when onsale=F? OR is there a better way to >do this.You may need to change the [saleprice] tag in your formula to [lookup >db=products.db&lookInField=SKU&value=[SKU]&returnField=saleprice]>2. Why does WebCatalog display the prices differently in identical >results.tmpl templates?Can't say there; either there's something subtle different in the search form itself, or the results template is wrong in both cases and you just got lucky one time.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com
Associated Messages, from the most recent to the oldest:
>1. How do I get WebCatalog to look up and display the saleprice when >onsale=T and the regular price when onsale=F? OR is there a better way to >do this.You may need to change the [saleprice] tag in your formula to [lookup >db=products.db&lookInField=SKU&value=[SKU]&returnField=saleprice]>2. Why does WebCatalog display the prices differently in identical >results.tmpl templates?Can't say there; either there's something subtle different in the search form itself, or the results template is wrong in both cases and you just got lucky one time.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com
Grant Hulbert
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] Still having problems (2008)
Quick ShowIf question (1997)
WebCat2b13MacPlugin - nested [xxx] contexts (1997)
negative less than (2000)
DOS variable bug (was SandBox and ImageMagick) (2003)
[WebDNA] v7 Stress Test and Strange Behaviour (2012)
syntax question, not in online refernce (1997)
Heads up, cookies *may* be outlawed in Europe (2001)
Counter for SKUs viewed (2002)
[taxrate] question (1997)
[HIDEIF] inside [FOUNDITEM] (1997)
[math] with first letter in field? (1997)
Setting up shop (1997)
More on the email templates (1997)
log out (2001)
RE: Answer: WebDelivery downloads alias, not original ? (1997)
webcat and OS 8 (1997)
Help! WebCat2 bug (1997)
Associative lookup style? + bit more (1997)
I'm new be kind (1997)