Index: openacs-4/packages/curriculum/www/ext-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/curriculum/www/ext-oracle.xql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/curriculum/www/ext-oracle.xql 10 Jun 2003 10:25:30 -0000 1.1
@@ -0,0 +1,22 @@
+
+
+ oracle8.1.6
+
+
+
+ insert into cu_user_element_map
+ (user_id, element_id, curriculum_id, package_id, completion_date)
+ select :user_id,
+ :element_id,
+ :curriculum_id,
+ :package_id,
+ sysdate
+ from dual
+ where not exists
+ (select 1 from cu_user_element_map
+ where user_id = :user_id
+ and element_id = :element_id)
+
+
+
+
Index: openacs-4/packages/curriculum/www/ext-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/curriculum/www/ext-postgresql.xql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/curriculum/www/ext-postgresql.xql 10 Jun 2003 10:25:30 -0000 1.1
@@ -0,0 +1,21 @@
+
+
+ postgresql7.1
+
+
+
+ insert into cu_user_element_map
+ (user_id, element_id, curriculum_id, package_id, completion_date)
+ select :user_id,
+ :element_id,
+ :curriculum_id,
+ :package_id,
+ current_timestamp
+ where not exists
+ (select 1 from cu_user_element_map
+ where user_id = :user_id
+ and element_id = :element_id)
+
+
+
+