Index: openacs-4/packages/ecommerce/ecommerce.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/ecommerce.info,v
diff -u -r1.29.2.2 -r1.29.2.3
--- openacs-4/packages/ecommerce/ecommerce.info	17 Oct 2002 02:49:12 -0000	1.29.2.2
+++ openacs-4/packages/ecommerce/ecommerce.info	17 Oct 2002 04:33:26 -0000	1.29.2.3
@@ -403,6 +403,8 @@
             <file type="query_file" path="www/admin/orders/items-void-2.xql"/>
             <file type="content_page" path="www/admin/orders/items-void.tcl"/>
             <file type="query_file" path="www/admin/orders/items-void.xql"/>
+            <file type="query_file" db_type="oracle" path="www/admin/orders/one-oracle.xql"/>
+            <file type="query_file" db_type="postgresql" path="www/admin/orders/one-postgresql.xql"/>
             <file type="content_page" path="www/admin/orders/one.tcl"/>
             <file type="query_file" path="www/admin/orders/one.xql"/>
             <file type="query_file" db_type="oracle" path="www/admin/orders/refunds-oracle.xql"/>
Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/ecommerce/www/admin/orders/one-oracle.xql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/ecommerce/www/admin/orders/one-postgresql.xql'.
Fisheye: No comparison available.  Pass `N' to diff?
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.2.2.1
--- 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	17 Oct 2002 04:33:25 -0000	1.2.2.1
@@ -1,19 +1,6 @@
 <?xml version="1.0"?>
 <queryset>
-
-  <fullquery name="order_select">
-    <querytext>
-      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
-    </querytext>
-  </fullquery>
-  
+ 
   <fullquery name="voided_by_name_select">      
     <querytext>
       select first_names || ' ' || last_name