Webmaster Forum / ASP / Database Access / December 2007

Hi,

I am new to writing stored procedure on sql server. I trying to write
a stored procedure for a shopping cart. I need to get the price for
dvd based on quantity from a price table.

select price from price where price.producttype =
shoppingcart.producttype AND
            price.quantity = shoppingcart.quantity

When I execute the sql code, I get this error

The multi-part identifier "shoppingcart.producttype" could not be
bound.

I also get the same error for

shoppingcart.quantity"

How do I fix this error?

I appreciate any help. Thanks.

ALTER PROCEDURE [dbo].[sp_getShoppingCartItems]
(@CartID char(36))
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    -- Get the price based on producttype and quantity
    DECLARE @price money
    --select price from price where producttype =
shoppingcart.producttype

   select price from price where price.producttype =
shoppingcart.producttype AND
            price.quantity = shoppingcart.quantity
    SELECT dvd.product_id, dvd.title, shoppingcart.quantity,
          price.price * shoppingcart.quantity AS Subtotal
    FROM shoppingcart INNER JOIN dvd
    ON shoppingcart.product_id = dvd.product_id
    WHERE shoppingcart.cart_id = @CartID
END