Index: openacs-4/packages/acs-tcl/tcl/site-nodes-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/site-nodes-procs-oracle.xql,v
diff -u -N -r1.4 -r1.5
--- openacs-4/packages/acs-tcl/tcl/site-nodes-procs-oracle.xql 1 Dec 2001 17:55:16 -0000 1.4
+++ openacs-4/packages/acs-tcl/tcl/site-nodes-procs-oracle.xql 1 Feb 2002 15:16:20 -0000 1.5
@@ -21,13 +21,13 @@
-
+
select site_node.url(n.node_id) as url, n.node_id, n.directory_p,
n.pattern_p, n.object_id, o.object_type, n.package_key, n.package_id
from acs_objects o, (select n.node_id, n.directory_p, n.pattern_p, n.object_id, p.package_key, p.package_id
from site_nodes n, apm_packages p
- where n.object_id = p.package_id) n
- where n.object_id = o.object_id
+ where n.object_id = p.package_id (+) ) n
+ where n.object_id = o.object_id (+);
Index: openacs-4/packages/acs-tcl/tcl/site-nodes-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/site-nodes-procs-postgresql.xql,v
diff -u -N -r1.8 -r1.9
--- openacs-4/packages/acs-tcl/tcl/site-nodes-procs-postgresql.xql 22 Jan 2002 16:09:02 -0000 1.8
+++ openacs-4/packages/acs-tcl/tcl/site-nodes-procs-postgresql.xql 1 Feb 2002 15:16:20 -0000 1.9
@@ -6,14 +6,13 @@
- select site_node__url(n.node_id) as url, n.node_id, n.directory_p,
- n.pattern_p, n.object_id, o.object_type, n.package_key, n.package_id
- from acs_objects o,
- (select n.node_id, n.directory_p, n.pattern_p, n.object_id,
- p.package_key, p.package_id
- from site_nodes n, apm_packages p
- where n.object_id = p.package_id) n
- where n.object_id = o.object_id
+select site_node__url(n.node_id) as url, n.node_id, n.directory_p,
+ n.pattern_p, n.object_id, o.object_type, p.package_key,
+ p.package_id
+ from site_nodes n
+ left join acs_objects o on n.object_id=o.object_id
+ left join apm_packages p
+ on n.object_id = p.package_id