Index: openacs-4/packages/download/www/admin/report-version-downloads-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/download/www/admin/report-version-downloads-oracle.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/download/www/admin/report-version-downloads-oracle.xql	23 May 2001 16:35:03 -0000	1.2
+++ openacs-4/packages/download/www/admin/report-version-downloads-oracle.xql	16 Jan 2003 13:46:20 -0000	1.3
@@ -6,18 +6,18 @@
 <fullquery name="download_table">
       <querytext>
       
-    select u.last_name || ', ' || u.first_names as user_name,
+    select u.user_id,
+           u.email,
+           u.last_name || ', ' || u.first_names as user_name,
            d.download_date,
            d.download_ip,
            nvl(d.download_hostname,'unavailable') as download_hostname,
            nvl(dar.version_name, 'unnamed') as version_name,
            dar.revision_id,
-           u.user_id,
-           u.email,
            nvl2(d.reason_id, dr.reason, d.reason) as reason
       from download_arch_revisions_obj dar, download_downloads d, download_reasons dr, cc_users u
      where d.user_id = u.user_id
-       and dar.archive_id = $archive_id
+       and dar.archive_id = :archive_id
        and dar.revision_id = d.revision_id
        and dr.download_reason_id(+) = d.reason_id
        [ad_dimensional_sql $dimensional where]
@@ -26,6 +26,7 @@
       </querytext>
 </fullquery>
 
+
 <partialquery name="version_clause">
       <querytext>