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 @@
oracle8.1.6
-
+
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
-
+