Index: openacs-4/packages/ecommerce/www/review-submit-2-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/review-submit-2-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ecommerce/www/review-submit-2-postgresql.xql	10 Jul 2001 20:42:02 -0000	1.1
+++ openacs-4/packages/ecommerce/www/review-submit-2-postgresql.xql	6 Jan 2002 07:22:48 -0000	1.2
@@ -13,7 +13,7 @@
     from ec_products,
          (select email as user_email
           from   cc_users
-          where  user_id = :user_id)
+          where  user_id = :user_id) as cc_emails
     where product_id=:product_id
 
       </querytext>
Index: openacs-4/packages/ecommerce/www/review-submit-3.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/review-submit-3.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ecommerce/www/review-submit-3.xql	10 Jul 2001 20:42:02 -0000	1.1
+++ openacs-4/packages/ecommerce/www/review-submit-3.xql	6 Jan 2002 07:22:48 -0000	1.2
@@ -9,7 +9,7 @@
 from   ec_products,
        (select count(*) as comment_found_p
         from   ec_product_comments
-        where  comment_id = :comment_id)
+        where  comment_id = :comment_id) ec_comments_count
 where  product_id = :product_id
 
       </querytext>