HomeHome Product Discus... Product Discus...SmithCartSmithCartHow does the cart work with the following code and data?How does the cart work with the following code and data?
Previous
 
Next
New Post
2/25/2011 9:50 AM
 

The sp to get the cart is

CREATE PROCEDURE [dbo].[Smith_GetShoppingCart]
(
@cartCookie varchar(30)
)
AS
BEGIN
SELECT * FROM Smith_ShoppingCart where [cartCookie] = @cartCookie
END

When I look in [Smith_ShoppingCart] in the db, I have multiple lines of the same @cartCookie/productID/unit cost/sku.

How can it possibly work giving that combination? Shouldn't it delete out the original record when quantities change etc? Does it just use the highest CartID increment?

 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartHow does the cart work with the following code and data?How does the cart work with the following code and data?