Index: openacs-4/packages/acs-subsite/tcl/party-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/tcl/Attic/party-procs.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/acs-subsite/tcl/party-procs.xql 6 May 2001 21:40:21 -0000 1.1 +++ openacs-4/packages/acs-subsite/tcl/party-procs.xql 15 May 2001 16:59:00 -0000 1.2 @@ -12,39 +12,4 @@ - - --- FIX ME DECODE (USE SQL92 CASE) - select - types.pretty_name, - types.object_type, - types.tree_level, - types.indent, - decode(valid_types.object_type, null, 0, 1) as valid_p - from - (select - t.pretty_name, t.object_type, level as tree_level, - replace(lpad(' ', (level - 1) * 4), - ' ', ' ') as indent, - rownum as tree_rownum - from - acs_object_types t - connect by - prior t.object_type = t.supertype - start with - $start_with_clause ) types, - (select - object_type - from - rel_types_valid_obj_two_types - where - rel_type = :rel_type ) valid_types - where - types.object_type = valid_types.object_type(+) - order by tree_rownum - - - - -