Index: openacs-4/packages/ecommerce/tcl/ecommerce-credit-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/tcl/ecommerce-credit-procs.xql,v
diff -u -N -r1.2 -r1.3
--- openacs-4/packages/ecommerce/tcl/ecommerce-credit-procs.xql 26 May 2002 04:36:49 -0000 1.2
+++ openacs-4/packages/ecommerce/tcl/ecommerce-credit-procs.xql 12 Sep 2002 22:45:47 -0000 1.3
@@ -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
-
-