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.34 -r1.35
--- openacs-4/packages/xotcl-core/tcl/05-db-procs.tcl	5 Sep 2007 22:54:50 -0000	1.34
+++ openacs-4/packages/xotcl-core/tcl/05-db-procs.tcl	12 Sep 2007 11:27:19 -0000	1.35
@@ -213,7 +213,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_clause $group_clause $order_clause $limit_clause"
+      return "SELECT $vars FROM $from $where_clause $group_clause $order_clause $limit_clause $offset_clause"
     }
 
     sql proc date_trunc {field date} {