Index: openacs-4/packages/ecommerce/tcl/ecommerce-state-changes-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/tcl/ecommerce-state-changes-procs-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ecommerce/tcl/ecommerce-state-changes-procs-oracle.xql	10 Jul 2001 20:38:43 -0000	1.1
+++ openacs-4/packages/ecommerce/tcl/ecommerce-state-changes-procs-oracle.xql	22 Jul 2001 04:51:03 -0000	1.2
@@ -23,6 +23,13 @@
       </querytext>
 </fullquery>
 
+
+<fullquery name="ec_update_state_to_confirmed.order_state_update">
+      <querytext>
+      update ec_orders set order_state='confirmed', confirmed_date=sysdate where order_id=:order_id
+      </querytext>
+</fullquery>
+
  
 <fullquery name="ec_update_state_to_confirmed.total_amount_select">      
       <querytext>
Index: openacs-4/packages/ecommerce/tcl/ecommerce-state-changes-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/tcl/ecommerce-state-changes-procs-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/ecommerce/tcl/ecommerce-state-changes-procs-postgresql.xql	11 Jul 2001 05:22:37 -0000	1.2
+++ openacs-4/packages/ecommerce/tcl/ecommerce-state-changes-procs-postgresql.xql	22 Jul 2001 04:51:03 -0000	1.3
@@ -25,6 +25,13 @@
       </querytext>
 </fullquery>
 
+
+<fullquery name="ec_update_state_to_confirmed.order_state_update">
+      <querytext>
+      update ec_orders set order_state='confirmed', confirmed_date=current_timestamp where order_id=:order_id
+      </querytext>
+</fullquery>
+
  
 <fullquery name="ec_update_state_to_confirmed.total_amount_select">      
       <querytext>