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.4.1 -r1.2.4.2
--- openacs-4/packages/download/www/admin/report-one-ip-oracle.xql	6 Dec 2002 11:31:28 -0000	1.2.4.1
+++ openacs-4/packages/download/www/admin/report-one-ip-oracle.xql	3 Jan 2003 17:29:47 -0000	1.2.4.2
@@ -15,10 +15,10 @@
            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>