Re: Two prices in shoppingcart?
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 12835
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.Theory..use a field that is called this_item_is_on_sale. Set the items onsale and via look-up or search that overides the price to the sale price.And when the sale is over you simple clear the fields on the sales itemsand it reverts back to the real price. We do something like this were weset various products as being the top twenty sellers by a product categoryand do various searchs and displays based on this and then once every 90days we tell webcatalog to change the fields back to and then use atemplate and reload the new top 20 sellers for the prior 90 days by productcategory. Seems to me somthing with this same theory would work fortriggering which items on on sale. And then when the sale is over revertback to the standard price. Just a thought.===============================================Gary Richter PanaVise Products, Inc. 7540 Colbert Dr. Reno, Nevada 89511 Ph: 702.850.2900 Fx: 702.850.2929 Email: grichter@panavise.com http://www.panavise.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.Theory..use a field that is called this_item_is_on_sale. Set the items onsale and via look-up or search that overides the price to the sale price.And when the sale is over you simple clear the fields on the sales itemsand it reverts back to the real price. We do something like this were weset various products as being the top twenty sellers by a product categoryand do various searchs and displays based on this and then once every 90days we tell webcatalog to change the fields back to and then use atemplate and reload the new top 20 sellers for the prior 90 days by productcategory. Seems to me somthing with this same theory would work fortriggering which items on on sale. And then when the sale is over revertback to the standard price. Just a thought.===============================================Gary Richter PanaVise Products, Inc. 7540 Colbert Dr. Reno, Nevada 89511 Ph: 702.850.2900 Fx: 702.850.2929 Email: grichter@panavise.com http://www.panavise.com===============================================
grichter@panavise.com (Gary Richter)
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:
Re[2]: Hierarchy of form/text/math variables (2000)
form data submission gets truncated (1997)
Platform Switch (1997)
Date format problems (1997)
Hello??? (1997)
Bug at start of Apache 2 with iTools 7 (2003)
WebCatalog2 Feature Feedback (1996)
Freeze (2003)
http or https (2005)
[format 40s]text[/format] doesn't work (1997)
Nested tags count question (1997)
showif (1999)
Make sure I understand this??? (1997)
ssl support WDNA 5.0 (2003)
acrobat -> wc (1998)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
RE: [WebDNA] Circumnavigate Browser Timeout On Lengthy WebDNA Operations (2014)
processing .html pages (2001)
Clearly.home (1998)
'page impression' techniques for banner ads (1999)