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