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:
summ=T (2003)
form data submission gets truncated (1997)
WebMerchant Error (1998)
Search Engine questions ... (2002)
MacFinder -- a new WebDNA web site (1998)
WebDNA 5.0 Questions (2003)
WebCat2b13MacPlugIn - syntax to convert date (1997)
RE: [WebDNA] HTTP Streaming - POSSIBLE! (2010)
[WebDNA] a major shift in strategy? (2008)
Re(2): SSL, WebSTAR, WebCatalog (1998)
protect tag on NT IIS (1997)
[WebDNA] Parallels machine (inspired by Amazon EC2 discussion) (2009)
Problems getting parameters passed into email. (1997)
Alpha List for Catagory (1998)
Version f1 status (1997)
Possible Bug in 2.0b15.acgi (1997)
WebCat2: Formulas.db question (1997)
carriage returns in data (1997)
wc 2 pro users - sites, quotes wanted (1997)
WebDNA Mail issues (2002)