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.2 -r1.3 --- openacs-4/packages/ecommerce/www/review-submit-2-postgresql.xql 6 Jan 2002 07:22:48 -0000 1.2 +++ openacs-4/packages/ecommerce/www/review-submit-2-postgresql.xql 26 May 2002 04:36:50 -0000 1.3 @@ -1,23 +1,19 @@ - postgresql7.1 + + postgresql + 7.1 + - - - - select product_name, - ec_product_comment_id_sequence.nextval as comment_id, - user_email, - to_char(current_timestamp,'Day Month DD, YYYY') as current_date - from ec_products, - (select email as user_email - from cc_users - where user_id = :user_id) as cc_emails - where product_id=:product_id + + + select product_name, ec_product_comment_id_sequence.nextval as comment_id, user_email, to_char(current_timestamp,'Day Month DD, YYYY') as current_date + from ec_products, (select email as user_email + from cc_users + where user_id = :user_id) as cc_emails + where product_id=:product_id + + - - - -