Index: openacs.org-dev/packages/ecommerce/tcl/ecommerce-credit-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs.org-dev/packages/ecommerce/tcl/ecommerce-credit-procs.xql,v diff -u -r1.1.1.1 -r1.1.1.2 --- openacs.org-dev/packages/ecommerce/tcl/ecommerce-credit-procs.xql 9 Jul 2002 17:35:05 -0000 1.1.1.1 +++ openacs.org-dev/packages/ecommerce/tcl/ecommerce-credit-procs.xql 8 Oct 2002 15:47:05 -0000 1.1.1.2 @@ -17,22 +17,6 @@ where transaction_id = :transaction_id - - - - 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, - a.zip_code as billing_zip, - a.line1 as billing_address, - a.city as billing_city, - coalesce(a.usps_abbrev, a.full_state_name) as billing_state, - a.country_code as billing_country - from ec_creditcards c, persons p, ec_addresses a - where c.user_id=p.person_id - and c.creditcard_id = :creditcard_id - and c.billing_address = a.address_id - -