Index: openacs-4/packages/ecommerce/www/gift-certificate-claim-2-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/gift-certificate-claim-2-postgresql.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/ecommerce/www/gift-certificate-claim-2-postgresql.xql 10 Jul 2001 20:42:02 -0000 1.1 +++ openacs-4/packages/ecommerce/www/gift-certificate-claim-2-postgresql.xql 26 May 2002 04:36:50 -0000 1.2 @@ -1,35 +1,33 @@ - postgresql7.1 + + postgresql + 7.1 + - - + + insert into ec_problems_log - (problem_id, problem_date, problem_details) - values - (ec_problem_id_sequence.nextval, current_timestamp,:prob_details ) - - - + (problem_id, problem_date, problem_details) + values + (ec_problem_id_sequence.nextval, current_timestamp,:prob_details ) + + - - - + + update ec_gift_certificates set user_id=:user_id, claimed_date=current_timestamp where gift_certificate_id=:gift_certificate_id - - + + - - - + + insert into ec_problems_log - (problem_id, problem_date, gift_certificate_id, problem_details) - values - (ec_problem_id_sequence.nextval, current_timestamp, :gift_certificate_id, :prob_details) - - - + (problem_id, problem_date, gift_certificate_id, problem_details) + values + (ec_problem_id_sequence.nextval, current_timestamp, :gift_certificate_id, :prob_details) + + -