Index: openacs-4/packages/ecommerce/www/shopping-cart-delete-from.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/shopping-cart-delete-from.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/ecommerce/www/shopping-cart-delete-from.xql 10 Jul 2001 20:42:02 -0000 1.1 +++ openacs-4/packages/ecommerce/www/shopping-cart-delete-from.xql 26 May 2002 04:36:50 -0000 1.2 @@ -1,18 +1,25 @@ + - - - select order_id from ec_orders where user_session_id=:user_session_id and order_state='in_basket' - - + + + select order_id + from ec_orders + where user_session_id=:user_session_id + and order_state='in_basket' + + - - - - delete from ec_items where order_id=:order_id and product_id=:product_id and color_choice [ec_decode $color_choice "" "is null" "= :color_choice"] and size_choice [ec_decode $size_choice "" "is null" "= :size_choice"] and style_choice [ec_decode $style_choice "" "is null" "= :style_choice"] - - + + + delete from ec_items + where order_id=:order_id + and product_id=:product_id + and color_choice [ec_decode $color_choice "" "is null" "= :color_choice"] + and size_choice [ec_decode $size_choice "" "is null" "= :size_choice"] + and style_choice [ec_decode $style_choice "" "is null" "= :style_choice"] + + -