Index: openacs-4/packages/xotcl-core/tcl/05-db-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/xotcl-core/tcl/05-db-procs.tcl,v
diff -u -N -r1.26 -r1.27
--- openacs-4/packages/xotcl-core/tcl/05-db-procs.tcl	11 Jun 2007 11:40:35 -0000	1.26
+++ openacs-4/packages/xotcl-core/tcl/05-db-procs.tcl	12 Jun 2007 10:09:13 -0000	1.27
@@ -180,7 +180,7 @@
         }
         # for pagination, we will need an "inner" sort, such as 
         # SELECT * FROM (SELECT ...., ROW_NUMBER() OVER (ORDER BY ...) R FROM table) WHERE R BETWEEN 0 and 100 
-        set sql "SELECT * FROM ($sql) WHERE $limit_clause $order_clause"
+        set sql "SELECT * FROM ($sql $order_clause) WHERE $limit_clause"
       } else {
         append sql " " $order_clause
       }