Index: openacs-4/packages/ecommerce/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/index-postgresql.xql,v
diff -u -N -r1.5 -r1.6
--- openacs-4/packages/ecommerce/www/index-postgresql.xql	13 Jan 2005 13:57:59 -0000	1.5
+++ openacs-4/packages/ecommerce/www/index-postgresql.xql	11 Aug 2008 07:02:30 -0000	1.6
@@ -23,14 +23,24 @@
     </querytext>
   </fullquery>
 
+  <fullquery name="get_tl_product_count">
+    <querytext>
+      select count(*) as product_count
+      from ec_products_searchable p left outer join ec_user_session_offer_codes o on (p.product_id = o.product_id and user_session_id = :user_session_id)
+      where not exists (select 1 
+          from ec_category_product_map m
+          where p.product_id = m.product_id)
+    </querytext>
+  </fullquery>
+
   <fullquery name="get_tl_products">      
     <querytext>
       select p.product_id, p.product_name, p.one_line_description, o.offer_code
       from ec_products_searchable p left outer join ec_user_session_offer_codes o on (p.product_id = o.product_id and user_session_id = :user_session_id)
       where not exists (select 1 
           from ec_category_product_map m
           where p.product_id = m.product_id)
-      order by p.product_name
+      order by p.product_name limit :how_many offset :start_row
     </querytext>
   </fullquery>