Index: openacs-4/packages/download/www/admin/approve-or-reject-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/download/www/admin/approve-or-reject-oracle.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/download/www/admin/approve-or-reject-oracle.xql	22 May 2001 04:17:45 -0000	1.2
+++ openacs-4/packages/download/www/admin/approve-or-reject-oracle.xql	23 May 2001 16:35:03 -0000	1.3
@@ -4,16 +4,17 @@
    <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
 <fullquery name="revision_info_select">      
-      <querytext>
+<querytext>
       
 select da.repository_id as repository_id,
+       da.archive_id,
        da.archive_name,
        da.summary,
        dar.revision_id,
        dar.file_name,
        dar.version_name,
        round(dbms_lob.getlength(dar.content)/1024) as file_size,
-       case when da.latest_revision = dar.revision_id then 't' else 'f' end as current_version_p,
+       decode(da.latest_revision, dar.revision_id, 't', 'f') as current_version_p,
        dar.creation_user,
        dar.creation_date,
        u.last_name || ', ' || u.first_names as creation_user_name
@@ -24,7 +25,7 @@
        dar.revision_id = :revision_id and
        u.user_id = dar.creation_user
 
-      </querytext>
+</querytext>
 </fullquery>