Two prices in shoppingcart?

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 12810
interpreted = N
texte = Hi all,Well, I'm still trying to figure out how to test in the database for whether an item is on sale and then return the appropriate price to the shopping cart.I have no problem looking up an item by its SKU and then getting its sale price as in the formula below. and in fact I use it to do a search and display the items that are on sale for the week.[lookup db=MusicBeach.db&lookInField=SKU&value=[SKU]&returnField=saleprice]I thought from something I read or Grant said or voices in my head in a dream suggested that the act of adding something to the cart triggered the lookup in the price part of the Formulas.db database, so I put the following formula in thereprice [lookup db=MusicBeach.db&lookInField=sku&value=[sku]&returnfield=salepriceThinking that because I was adding to the cart with the URL link on the results page, I would look up the price for just the sku on the saleResults page and it would put that special price into the shopping cart line item. But it puts the regular price in there instead.What i want to do is put things from the ON SALE page into the shopping cart with the sale price and things from the NOT ON SALE page to put things into the shopping cart with the regular price. Is that too much to ask? Am I just a crazy dreamer? Is there a solution to my problem? Are all the hours of looking at [ and ] finally taking their toll? Will anyone care in 1000 years. Is the meaning of life really a hamburger?This inquiring mind wants to know . . . is seems to be wandering a bit.Better call it a night. ANY help would be appreciated!!Jerry Nielsen - commSTRUCT Associates 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)
Hi all,Well, I'm still trying to figure out how to test in the database for whether an item is on sale and then return the appropriate price to the shopping cart.I have no problem looking up an item by its SKU and then getting its sale price as in the formula below. and in fact I use it to do a search and display the items that are on sale for the week.[lookup db=MusicBeach.db&lookInField=SKU&value=[SKU]&returnField=saleprice]I thought from something I read or Grant said or voices in my head in a dream suggested that the act of adding something to the cart triggered the lookup in the price part of the formulas.db database, so I put the following formula in thereprice [lookup db=MusicBeach.db&lookInField=sku&value=[sku]&returnfield=salepriceThinking that because I was adding to the cart with the URL link on the results page, I would look up the price for just the sku on the saleResults page and it would put that special price into the shopping cart line item. But it puts the regular price in there instead.What i want to do is put things from the ON SALE page into the shopping cart with the sale price and things from the NOT ON SALE page to put things into the shopping cart with the regular price. Is that too much to ask? Am I just a crazy dreamer? Is there a solution to my problem? Are all the hours of looking at [ and ] finally taking their toll? Will anyone care in 1000 years. Is the meaning of life really a hamburger?This inquiring mind wants to know . . . is seems to be wandering a bit.Better call it a night. ANY help would be appreciated!!Jerry Nielsen - commSTRUCT Associates

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:

[OT] Javascript help (2007) [WebDNA] Capitalize surprise (2012) spook tcpconnect? (1999) Adding more than one item and QTY to cart (2000) is sku a REQUIRED field on NT (1997) [OT] ODBC between IIS and remote Access problem (2000) Help with Repost Data msg from form (1997) Re:PCS Customer submissions ? (1997) Pull Down Search (2000) tag request (1999) range vs greater than/less than (2003) Where is the secure setting for text variables? (2003) [WriteFile] problems (1997) NT or Mac (1997) WebDNA EMail Preference (2005) FIXED: Startup Script for 5.1g on iTools 8.2 (2006) Displaying photo attached to first record (1997) no shopping cart (2000) [WebDNA] WebDNA slow processing (2011) triggers have stopped once again (2002)