Index: openacs-4/packages/ecommerce/www/admin/customer-service/interaction-add-3-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/customer-service/interaction-add-3-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ecommerce/www/admin/customer-service/interaction-add-3-postgresql.xql	10 Jul 2001 20:33:53 -0000	1.1
+++ openacs-4/packages/ecommerce/www/admin/customer-service/interaction-add-3-postgresql.xql	26 Aug 2001 23:03:42 -0000	1.2
@@ -30,5 +30,43 @@
       </querytext>
 </fullquery>
 
+
+<partialquery name="date_string_sql">
+      <querytext>
+
+      to_timestamp(:open_date_str,'YYYY-MM-DD HH24:MI:SS')
+
+      </querytext>
+</partialquery>
+
+
+<partialquery name="customer_service_rep_bit_null_sql">
+      <querytext>
+
+      null
+
+      </querytext>
+</partialquery>
+
+
+<partialquery name="close_date_null_sql">
+      <querytext>
+
+      null
+
+      </querytext>
+</partialquery>
+
+
+<fullquery name="insert_new_ec_cs_issue">
+      <querytext>
+      insert into ec_customer_service_issues
+      (issue_id, user_identification_id, order_id, open_date, close_date, closed_by)
+      values
+      (:issue_id, :uiid_to_insert, :order_id, $date_string, $close_date, $customer_service_rep_bit)
+
+      </querytext>
+</fullquery>
+
  
 </queryset>