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 Solution11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMasterSan Diego, CA 92128 | SiteGuard619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com Associated Messages, from the most recent to the oldest:

Re: Looking up two prices in database? (Grant Hulbert 1997) Re: Looking up two prices in database? ( 1997) Re: Looking up two prices in database? (Grant Hulbert 1997) Re: Looking up two prices in database? ( 1997) Re: Looking up two prices in database? (Grant Hulbert 1997) Looking up two prices in database? ( 1997)

>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 Solution11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMasterSan Diego, CA 92128 | SiteGuard619/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:

removing commas from a preformatted number (2000) Summing fields (1997) Not really WebCat- (1997) [WebDNA] Grep out square brackets? (2010) Multi-processor Mac info ... (1997) Accepting credit cards (1997) WebCatalog2 Feature Feedback (1996) [WebDNA] How do we tell what's misconfigured? Or which WebDNA 7 version to use? (2011) NT version and O'reily's WebSite (1997) ftp ng (1999) Help with Repost Data msg from form (1997) Resume Catalog ? (1997) [MATH SHOW=F]. show=f does what? (1999) Signal Raised (1997) help needed w/ search params (1998) credit card (1997) WC1.6 to WC2 date formatting (1997) redirect with frames (1997) Almost a there but..bye bye NetCloak (1997) Search in 2 or more catalogs (1997)