Index: openacs-4/packages/dotlrn/coding-tips.txt
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/Attic/coding-tips.txt,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/dotlrn/coding-tips.txt	25 Jan 2002 16:21:27 -0000	1.1
+++ openacs-4/packages/dotlrn/coding-tips.txt	18 Feb 2002 01:53:31 -0000	1.2
@@ -3,7 +3,8 @@
 ----------
 
 - You CANNOT nest the <multiple> tag in a single template. Use the <include>
-  tag instead. Pass in the necessary vars. 
+  tag instead. Pass in the necessary vars. Somebody made a patch to 
+  nest multiples, but it's not in the tree yet (as of 2/16/02).
 
 - in <include> tags, you can pass a datasource (i.e. a <multiple>) using the
   "&=" notation. E.g. from /new-portal/www/place-element.adp
@@ -13,3 +14,20 @@
              portal_id=@portal_id@
              page_id=@element_multi.page_id@>
   
+PL/SQL
+------
+
+- You can't have a package with the same name as a table! If you do this
+  you get "ORA-00955: name is already used by an existing object" errors
+
+- Always use fully qualified argument names in procs and funcs:
+
+  e.g. in a func named "new" with args "instance_id" and "content"
+
+        insert into static_portal_content
+        (instance_id, content)
+        values
+        (new.instance_id, new.content);
+
+
+   
Index: openacs-4/packages/dotlrn/dotlrn.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/dotlrn.info,v
diff -u -r1.51 -r1.52
--- openacs-4/packages/dotlrn/dotlrn.info	14 Feb 2002 18:03:07 -0000	1.51
+++ openacs-4/packages/dotlrn/dotlrn.info	18 Feb 2002 01:53:31 -0000	1.52
@@ -96,7 +96,6 @@
             <file type="query_file" db_type="postgresql" path="tcl/dotlrn-procs-postgresql.xql"/>
             <file type="tcl_procs" path="tcl/dotlrn-procs.tcl"/>
             <file type="query_file" path="tcl/dotlrn-procs.xql"/>
-            <file type="tcl_procs" path="tcl/dotlrn-professor-profile-provider-procs.tcl"/>
             <file type="query_file" db_type="oracle" path="tcl/dotlrn-security-procs-oracle.xql"/>
             <file type="tcl_procs" path="tcl/dotlrn-security-procs.tcl"/>
             <file type="query_file" path="tcl/dotlrn-security-procs.xql"/>
@@ -290,6 +289,8 @@
             <file type="content_page" path="www/spam.adp"/>
             <file type="content_page" path="www/spam.tcl"/>
             <file type="query_file" path="www/spam.xql"/>
+            <file type="content_page" path="www/subcommunity-new.adp"/>
+            <file type="content_page" path="www/subcommunity-new.tcl"/>
             <file type="content_page" path="www/user-add-2.adp"/>
             <file type="content_page" path="www/user-add-2.tcl"/>
             <file type="content_page" path="www/user-add-3.tcl"/>