Index: openacs-4/packages/ecommerce/tcl/ecommerce-credit-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/tcl/ecommerce-credit-procs-postgresql.xql,v diff -u -r1.7 -r1.8 --- openacs-4/packages/ecommerce/tcl/ecommerce-credit-procs-postgresql.xql 30 Nov 2002 17:31:18 -0000 1.7 +++ openacs-4/packages/ecommerce/tcl/ecommerce-credit-procs-postgresql.xql 8 Mar 2004 19:46:11 -0000 1.8 @@ -9,7 +9,7 @@ select c.creditcard_number as card_number, substring(creditcard_expire for 2) as card_exp_month, substring(creditcard_expire from 4 for 2) as card_exp_year, - c.creditcard_type, p.first_names || ' ' || p.last_name as card_name, + c.creditcard_type, a.attn as card_name, a.zip_code as billing_zip, a.line1 as billing_address, a.city as billing_city, @@ -24,7 +24,7 @@ - select f.transaction_amount, f.transaction_id, c.creditcard_type, p.first_names || ' ' || p.last_name as card_name, + select f.transaction_amount, f.transaction_id, c.creditcard_type, a.attn as card_name, c.creditcard_number as card_number, substring(creditcard_expire for 2) as card_exp_month, substring(creditcard_expire from 4 for 2) as card_exp_year, c.creditcard_type, a.zip_code as billing_zip, a.line1 as billing_address, @@ -43,7 +43,7 @@ select t.refunded_transaction_id, t.transaction_amount, c.creditcard_number as card_number, substring(creditcard_expire for 2) as card_exp_month, substring(creditcard_expire from 4 for 2) as card_exp_year, c.creditcard_type, - p.first_names || ' ' || p.last_name as card_name, + a.attn as card_name, a.zip_code as billing_zip, a.line1 as billing_address, a.city as billing_city,