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:
>[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:
WebMerchant 3.0 for Mac shipping now (1998)
Verbose error reporting (1998)
unsubscribe (1997)
Order not created error (never mind) (1997)
suffix mapping, use of cache, etc. (1997)
turning every 5th line red (1998)
WebCatalog for guestbook ? (1997)
OT: Need (a tiny bit) of help setting up MySQL (2000)
WebSTAR 2.1 freezes my Mac (1997)
Authorize.net (2001)
foreign languages, email, webcat (1998)
Date AND time (2001)
Newbie Help Needed (1998)
Proper file locations (1997)
Which GUI HTML editors work with WC ? (1997)
can webcat determine an image's pixel dimensions? (2000)
Extended [ConvertChars] (1997)
calculating tax rates, mail order solutions and version 2 (1997)
no global [username] or [password] displayed ... (1997)
Order not created error (1997)