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:
Strange intermittent WebDNA problems (2008)
textA (1998)
[OT] Theiving B*****ds (2004)
WebCatalog and WebMerchant reviewed by InfoWorld (1997)
Generating unique SKU from [cart] - Still Stumped... (1997)
[HIDEIF] inside [FOUNDITEM] (1997)
Car Database - Imporant (2002)
RE: WebDNA-Talk searchable? (1997)
Search inside Include (1998)
Multiple adding (1997)
carriage returns in data (1997)
WebCat2b15MacPlugin - showing [math] (1997)
quick GREP question (2001)
Re[2]: Re[2]: WebCatalog keeps quiting on Solaris, and suppo (2000)
Re:quit command on NT (1997)
WebCat2_Mac RETURNs in .db (1997)
Help! WebCat2 bug (1997)
too many nested [xxx] (1997)
Validation (2000)
A multi-processor savvy WebCatalog? (1997)