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:

WebCatalog for Postcards ? (1997) multiple databases (1997) Server crashes when user saves or views html source (1998) contextual shownext (1998) More questions about serial number dishing (1997) [/application] error? (1997) [cart] tag (2000) Searchable list archive (1997) Summing fields (1997) [authenticate] (1999) Server Traffic Simulation (1998) multi-paragraph fields (1997) Fwd: Image Pirating [protecting against] (2003) The List is Changing (1997) ImageMagick on OSX (2003) Shared databases (2003) Move WebDNA DB to MySQL (2005) Was: Variables not being passed *back* (2000) Highlighting words found in a keyword search (2003) Problems with [Search] param - Mac Plugin b15 (1997)