Index: openacs-4/packages/ecommerce/www/category-browse-subcategory-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/category-browse-subcategory-oracle.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/ecommerce/www/category-browse-subcategory-oracle.xql	11 Aug 2008 07:13:50 -0000	1.3
+++ openacs-4/packages/ecommerce/www/category-browse-subcategory-oracle.xql	20 Dec 2008 12:05:34 -0000	1.4
@@ -49,7 +49,7 @@
       order by p.product_name
             ) q
         ) r
-        where r_rownum > :start_row
+        where r_rownum => :start_row
         and r_rownum <= :start_row + :how_many
     </querytext>
   </fullquery>
Index: openacs-4/packages/ecommerce/www/category-browse-subcategory-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/category-browse-subcategory-postgresql.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/ecommerce/www/category-browse-subcategory-postgresql.xql	11 Aug 2008 07:13:50 -0000	1.3
+++ openacs-4/packages/ecommerce/www/category-browse-subcategory-postgresql.xql	20 Dec 2008 12:05:34 -0000	1.4
@@ -41,7 +41,7 @@
       where p.product_id = m.product_id
       and m.${sub}category_id = :${sub}category_id
       $exclude_subproducts
-      order by p.product_name limit :how_many offset :start_row
+      order by p.product_name limit :how_many offset :start_db_row
     </querytext>
   </fullquery>
 
Index: openacs-4/packages/ecommerce/www/category-browse-subcategory.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/category-browse-subcategory.tcl,v
diff -u -r1.15 -r1.16
--- openacs-4/packages/ecommerce/www/category-browse-subcategory.tcl	12 Aug 2008 12:23:58 -0000	1.15
+++ openacs-4/packages/ecommerce/www/category-browse-subcategory.tcl	20 Dec 2008 12:05:34 -0000	1.16
@@ -120,6 +120,8 @@
 #==============================
 # products
 
+set start_db_row [expr { $start_row - 1 } ]
+
 # All products in the "category" and not in "subcategories"
 
 set exclude_subproducts ""