Index: openacs-4/packages/acs-lang/www/admin/message-list-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/www/admin/Attic/message-list-oracle.xql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/acs-lang/www/admin/message-list-oracle.xql 11 Dec 2003 21:39:53 -0000 1.3 +++ openacs-4/packages/acs-lang/www/admin/message-list-oracle.xql 26 Feb 2004 15:28:47 -0000 1.4 @@ -10,7 +10,8 @@ select lmk.message_key, lm1.message as default_message, lm2.message as translated_message, - lmk.description + lmk.description, + nvl(lm2.deleted_p, 'f') as deleted_p from lang_messages lm1, lang_messages lm2, lang_message_keys lmk @@ -21,7 +22,6 @@ and lm2.locale (+) = :locale and lm2.message_key (+) = lmk.message_key and lm2.package_key (+) = lmk.package_key - and (lm2.deleted_p = 'f' or lm2.deleted_p is null) and lm1.deleted_p = 'f' $where_clause order by upper(lm1.message_key), lm1.message_key