Index: openacs-4/packages/dotlrn/tcl/term-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/tcl/Attic/term-procs-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/dotlrn/tcl/term-procs-oracle.xql	17 Dec 2001 23:02:56 -0000	1.1
+++ openacs-4/packages/dotlrn/tcl/term-procs-oracle.xql	14 Mar 2002 23:30:26 -0000	1.2
@@ -1,37 +1,48 @@
 <?xml version="1.0"?>
 
 <queryset>
-  <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+    <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
-  <fullquery name="dotlrn_term::new.insert_term">
-    <querytext>
-      insert
-      into dotlrn_terms
-      (term_id, term_name, term_year, start_date, end_date)
-      values
-      (acs_object_id_seq.nextval, :term_name, :term_year, to_date(:start_date, :date_format), to_date(:end_date, :date_format))
-    </querytext>
-  </fullquery>
+    <fullquery name="dotlrn_term::new.insert_term">
+        <querytext>
+            insert
+            into dotlrn_terms
+            (term_id, term_name, term_year, start_date, end_date)
+            values
+            (acs_object_id_seq.nextval, :term_name, :term_year, to_date(:start_date, :date_format), to_date(:end_date, :date_format))
+        </querytext>
+    </fullquery>
 
-  <fullquery name="dotlrn_term::get_start_date.get_start_date">
-    <querytext>
-      select to_char(dotlrn_terms.start_date, :date_format) as start_date,
-             to_char(dotlrn_terms.start_date, 'YYYY') as year,
-             to_char(dotlrn_terms.start_date, 'MM') as month,
-             to_char(dotlrn_terms.start_date, 'DD') as day
-      from dotlrn_terms
-      where dotlrn_terms.term_id = :term_id
-    </querytext>
-  </fullquery>
+    <fullquery name="dotlrn_term::edit.update_term">
+        <querytext>
+            update dotlrn_terms
+            set term_name = :term_name,
+                term_year = :term_year,
+                start_date = to_date(:start_date, :date_format),
+                end_date = to_date(:end_date, :date_format)
+            where term_id = :term_id
+        </querytext>
+    </fullquery>
 
-  <fullquery name="dotlrn_term::get_end_date.get_end_date">
-    <querytext>
-      select to_char(dotlrn_terms.end_date, :date_format) as end_date,
-             to_char(dotlrn_terms.end_date, 'YYYY') as year,
-             to_char(dotlrn_terms.end_date, 'MM') as month,
-             to_char(dotlrn_terms.end_date, 'DD') as day
-      from dotlrn_terms
-      where dotlrn_terms.term_id = :term_id
-    </querytext>
-  </fullquery>
+    <fullquery name="dotlrn_term::get_start_date.get_start_date">
+        <querytext>
+            select to_char(dotlrn_terms.start_date, :date_format) as start_date,
+                   to_char(dotlrn_terms.start_date, 'YYYY') as year,
+                   to_char(dotlrn_terms.start_date, 'MM') as month,
+                   to_char(dotlrn_terms.start_date, 'DD') as day
+            from dotlrn_terms
+            where dotlrn_terms.term_id = :term_id
+        </querytext>
+    </fullquery>
+
+    <fullquery name="dotlrn_term::get_end_date.get_end_date">
+        <querytext>
+            select to_char(dotlrn_terms.end_date, :date_format) as end_date,
+                   to_char(dotlrn_terms.end_date, 'YYYY') as year,
+                   to_char(dotlrn_terms.end_date, 'MM') as month,
+                   to_char(dotlrn_terms.end_date, 'DD') as day
+            from dotlrn_terms
+            where dotlrn_terms.term_id = :term_id
+        </querytext>
+    </fullquery>
 </queryset>