Index: openacs-4/packages/ecommerce/www/review-submit-2-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/review-submit-2-oracle.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/ecommerce/www/review-submit-2-oracle.xql 10 Jul 2001 20:42:02 -0000 1.1 +++ openacs-4/packages/ecommerce/www/review-submit-2-oracle.xql 26 May 2002 04:36:50 -0000 1.2 @@ -1,23 +1,19 @@ - oracle8.1.6 + + oracle + 8.1.6 + - - - - select product_name, - ec_product_comment_id_sequence.nextval as comment_id, - user_email, - to_char(sysdate,'Day Month DD, YYYY') as current_date - from ec_products, - (select email as user_email - from cc_users - where user_id = :user_id) - where product_id=:product_id + + + select product_name, ec_product_comment_id_sequence.nextval as comment_id, user_email, to_char(sysdate,'Day Month DD, YYYY') as current_date + from ec_products, (select email as user_email + from cc_users + where user_id = :user_id) + where product_id=:product_id + + - - - -