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