Index: openacs-4/packages/ecommerce/www/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/index-oracle.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/ecommerce/www/index-oracle.xql 26 May 2002 04:36:50 -0000 1.2
+++ openacs-4/packages/ecommerce/www/index-oracle.xql 12 Sep 2002 22:15:01 -0000 1.3
@@ -15,4 +15,16 @@
+
+
+ select p.product_id, p.product_name, p.one_line_description, o.offer_code
+ from ec_products_searchable p, ec_user_session_offer_codes o
+ where (p.product_id(+)=o.product_id and user_session_id = :user_session_id)
+ and not exists (select 1
+ from ec_category_product_map m
+ where p.product_id = m.product_id)
+ order by p.product_name
+
+
+
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 -r1.2 -r1.3
--- openacs-4/packages/ecommerce/www/index-postgresql.xql 26 May 2002 04:36:50 -0000 1.2
+++ openacs-4/packages/ecommerce/www/index-postgresql.xql 12 Sep 2002 22:15:01 -0000 1.3
@@ -13,4 +13,15 @@
+
+
+ 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
+
+
+
Index: openacs-4/packages/ecommerce/www/index.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/index.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/ecommerce/www/index.xql 26 May 2002 04:36:50 -0000 1.2
+++ openacs-4/packages/ecommerce/www/index.xql 12 Sep 2002 22:15:01 -0000 1.3
@@ -35,15 +35,4 @@
-
-
- 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
-
-
-