Re: Two prices in shoppingcart?

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 12834
interpreted = N
texte = >[lookup >db=MusicBeach.db&lookInField=SKU&value=[SKU]&returnField=saleprice]This should work fine. It almost exactly matches the example formula given with WebCatalog, which returns the price field instead of the saleprice field. Do you have a saleprice defined for every single item in your database, or is it sometimes blank? If it's blank sometimes, then this would not work, and the results would be unpredictable.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. Re: Two prices in shoppingcart? (grichter@panavise.com (Gary Richter) 1997)
  2. Re: Two prices in shoppingcart? (Grant Hulbert 1997)
  3. Two prices in shoppingcart? ( 1997)
>[lookup >db=MusicBeach.db&lookInField=SKU&value=[SKU]&returnField=saleprice]This should work fine. It almost exactly matches the example formula given with WebCatalog, which returns the price field instead of the saleprice field. Do you have a saleprice defined for every single item in your database, or is it sometimes blank? If it's blank sometimes, then this would not work, and the results would be unpredictable.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:

$append (1998) no template caching (1997) Help name our technology! I found it (1997) [WriteFile] problems (1997) Multi Actions (1999) [ShowIf] if the varieable exists (1998) Error:Too many nested [xxx] contexts (1997) refreshing IE with posted .tmpl (1997) How does the Globals folder work? (2000) SQL Error 22003 : Found the workaround (2001) Cache problem (2002) Two submit buttons ? (1997) Price Not Appearing (2000) Summaries (1999) Back to Authnet with storebuilder (2003) PIXO support (1997) Location of Browser Info.txt file (1997) RE: CloseDatabase (1997) Wanted: More Math Functions (or, Can You Solve This?) (1997) Calculating multiple shipping... (1997)