Index: openacs-4/packages/ecommerce/sql/postgresql/ecommerce-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/sql/postgresql/ecommerce-create.sql,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/ecommerce/sql/postgresql/ecommerce-create.sql	21 Aug 2001 04:43:45 -0000	1.9
+++ openacs-4/packages/ecommerce/sql/postgresql/ecommerce-create.sql	22 Aug 2001 03:08:03 -0000	1.10
@@ -1658,7 +1658,7 @@
             	ELSE
 		    IF n_shipped_items >= 1 or n_received_back_items >=1 THEN
 			update ec_orders set order_state=''partially_fulfilled''
-			    where order_id=v_order_id;
+			    where order_id=NEW.order_id;
             	    END IF;
         	END IF;
 	    END IF;