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.8 -r1.9 --- openacs-4/packages/ecommerce/tcl/ecommerce-credit-procs-postgresql.xql 8 Mar 2004 19:46:11 -0000 1.8 +++ openacs-4/packages/ecommerce/tcl/ecommerce-credit-procs-postgresql.xql 8 Sep 2008 10:35:13 -0000 1.9 @@ -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, a.attn 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, @@ -25,7 +25,7 @@ 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, + 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, a.city as billing_city,