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 -r1.2.2.2 -r1.2.2.3
--- openacs-4/packages/xotcl-core/tcl/05-db-procs.tcl	1 Aug 2007 21:39:32 -0000	1.2.2.2
+++ openacs-4/packages/xotcl-core/tcl/05-db-procs.tcl	12 Sep 2007 11:31:16 -0000	1.2.2.3
@@ -124,7 +124,7 @@
       set limit_clause  [expr {$limit   ne "" ? "LIMIT $limit" : ""}]
       set order_clause  [expr {$orderby ne "" ? "ORDER BY $orderby" : ""}]
       set group_clause  [expr {$groupby ne "" ? "GROUP BY $groupby" : ""}]
-      return "SELECT $vars FROM $from WHERE $where $group_clause $order_clause $limit_clause"
+      return "SELECT $vars FROM $from WHERE $where $group_clause $order_clause $limit_clause $offset_clause"
     }
 
     sql proc date_trunc {field date} {