Index: openacs-4/packages/dotlrn/www/admin/user-edit-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/user-edit-oracle.xql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/dotlrn/www/admin/user-edit-oracle.xql 9 Feb 2002 15:31:58 -0000 1.3 +++ openacs-4/packages/dotlrn/www/admin/user-edit-oracle.xql 14 Mar 2002 05:40:14 -0000 1.4 @@ -1,22 +1,22 @@ -oracle8.1.6 + oracle8.1.6 - - - select dotlrn_users.id, - dotlrn_users.first_names, - dotlrn_users.last_name, - dotlrn_users.email, - dotlrn_users.type, - case when dotlrn_full_user_profile_rels.rel_id is null then 'limited' else 'full' end as access_level, - acs_permission.permission_p(:dotlrn_package_id, :user_id, 'read_private_data') as read_private_data_p - from dotlrn_users, - dotlrn_full_user_profile_rels - where dotlrn_users.user_id = :user_id - and dotlrn_users.rel_id = dotlrn_full_user_profile_rels.rel_id(+) - + + + select dotlrn_users.id, + dotlrn_users.first_names, + dotlrn_users.last_name, + dotlrn_users.email, + dotlrn_users.type, + case when dotlrn_full_user_profile_rels.rel_id is null then 'limited' else 'full' end as access_level, + acs_permission.permission_p(:dotlrn_package_id, :user_id, 'read_private_data') as read_private_data_p + from dotlrn_users, + dotlrn_full_user_profile_rels + where dotlrn_users.user_id = :user_id + and dotlrn_users.rel_id = dotlrn_full_user_profile_rels.rel_id(+) +