Index: openacs-4/packages/ecommerce/www/admin/orders/one.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/orders/one.xql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/ecommerce/www/admin/orders/one.xql 26 May 2002 04:36:50 -0000 1.2 +++ openacs-4/packages/ecommerce/www/admin/orders/one.xql 30 Nov 2002 17:31:38 -0000 1.3 @@ -1,19 +1,6 @@ - - - - select o.order_state, o.creditcard_id, o.confirmed_date, o.cs_comments, - o.shipping_method, o.shipping_address, o.in_basket_date, - o.authorized_date, o.shipping_charged, o.voided_by, o.voided_date, - o.reason_for_void, u.user_id, u.first_names, u.last_name, c.billing_address - from ec_orders o - left join cc_users u using (user_id) - left join ec_creditcards c using (creditcard_id) - where order_id=:order_id - - - + select first_names || ' ' || last_name