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 on sale 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 items and it reverts back to the real price. We do something like this were we set various products as being the top twenty sellers by a product category and do various searchs and displays based on this and then once every 90 days we tell webcatalog to change the fields back to and then use a template and reload the new top 20 sellers for the prior 90 days by product category. Seems to me somthing with this same theory would work for triggering which items on on sale. And then when the sale is over revert back 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:

    
  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. Theory..use a field that is called this_item_is_on_sale. Set the items on sale 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 items and it reverts back to the real price. We do something like this were we set various products as being the top twenty sellers by a product category and do various searchs and displays based on this and then once every 90 days we tell webcatalog to change the fields back to and then use a template and reload the new top 20 sellers for the prior 90 days by product category. Seems to me somthing with this same theory would work for triggering which items on on sale. And then when the sale is over revert back 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)