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:

Nested vs conditional (1997) Up and running ... at last !! (1997) placement of ? (2000) RE: Subtotal help (1997) Sort Order on a page search (1997) FREE Stuff .. (2003) Frames and WebCat (1997) WILDWEBCAT encrypt.tpl submission (1998) Help! WebCat2 bug (1997) AAgghh!! Help, please. SSL strikes again. (1997) using showpage and showcart commands (1996) Which is Faster (1998) UPPERCASE (1997) [LOOKUP] (1997) Problem with Showif & Applescript (1997) Re(2): Share Bulletin Board? (1998) Writing to disk (1999) tax rate off by 1 cent (1997) Install Webcatalog under NT4.0 and Microsoft IIS 2.0 (1997) Search crashing server (1998)