Index: openacs-4/packages/download/www/admin/report-by-user-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/download/www/admin/report-by-user-postgresql.xql,v
diff -u -N -r1.1.4.1 -r1.1.4.2
--- openacs-4/packages/download/www/admin/report-by-user-postgresql.xql	6 Dec 2002 11:31:28 -0000	1.1.4.1
+++ openacs-4/packages/download/www/admin/report-by-user-postgresql.xql	3 Jan 2003 17:29:47 -0000	1.1.4.2
@@ -9,14 +9,13 @@
     select d.user_id,
            min(u.last_name || ', ' || u.first_names) as user_name,
            min(u.email) as email,
-           count(*) as num_downloads,
-           min('$downloaded'::varchar) as downloaded
+           count(*) as num_downloads
      from download_downloads_repository d, cc_users u
-     where d.repository_id = $repository_id and
+     where d.repository_id = :repository_id and
            d.user_id = u.user_id
            [ad_dimensional_sql $dimensional where]
      group by d.user_id
-     order by 2 desc
+     order by 2
 
       </querytext>
 </fullquery>