Index: openacs-4/packages/ecommerce/www/admin/customer-service/email-send-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/customer-service/email-send-oracle.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/ecommerce/www/admin/customer-service/email-send-oracle.xql 10 Jul 2001 20:33:53 -0000 1.1 +++ openacs-4/packages/ecommerce/www/admin/customer-service/email-send-oracle.xql 31 Jan 2002 06:41:59 -0000 1.2 @@ -1,25 +1,15 @@ - oracle8.1.6 + oracle8.1.6 - - - -select u.email as user_email, id.email as id_email - from cc_users u, ec_user_identification id - where id.user_id = u.user_id(+) - and id.user_identification_id=:user_identification_id + + + select u.email as user_email, id.email as id_email + from cc_users u, ec_user_identification id + where id.user_id = u.user_id(+) + and id.user_identification_id=:user_identification_id + + - - - - - - - select ec_action_id_sequence.nextval from dual - - - - - +