Index: openacs-4/packages/categories/www/cadmin/category-link-add-3-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/categories/www/cadmin/category-link-add-3-oracle.xql,v
diff -u -N
--- openacs-4/packages/categories/www/cadmin/category-link-add-3-oracle.xql 8 Feb 2004 17:30:45 -0000 1.1
+++ /dev/null 1 Jan 1970 00:00:00 -0000
@@ -1,23 +0,0 @@
-
-
-
- oracle8.1.6
-
-
-
-
- select c.category_id as link_category_id
- from categories c
- where c.category_id in ([join $link_category_id ,])
- and acs_permission.permission_p(c.tree_id,:user_id,'category_tree_write') = 't'
- and c.category_id <> :category_id
- and not exists (select 1
- from category_links l
- where l.from_category_id = :category_id
- and l.to_category_id = c.category_id)
-
-
-
-
-
-
Index: openacs-4/packages/categories/www/cadmin/category-link-add-3-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/categories/www/cadmin/category-link-add-3-postgresql.xql,v
diff -u -N
--- openacs-4/packages/categories/www/cadmin/category-link-add-3-postgresql.xql 8 Feb 2004 17:30:45 -0000 1.1
+++ /dev/null 1 Jan 1970 00:00:00 -0000
@@ -1,23 +0,0 @@
-
-
-
- postgresql7.1
-
-
-
-
- select c.category_id as link_category_id
- from categories c
- where c.category_id in ([join $link_category_id ,])
- and acs_permission__permission_p(c.tree_id,:user_id,'category_tree_write') = 't'
- and c.category_id <> :category_id
- and not exists (select 1
- from category_links l
- where l.from_category_id = :category_id
- and l.to_category_id = c.category_id)
-
-
-
-
-
-