Index: openacs-4/packages/ecommerce/tcl/ecommerce-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/tcl/ecommerce-procs-oracle.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/ecommerce/tcl/ecommerce-procs-oracle.xql	24 Nov 2001 03:52:22 -0000	1.4
+++ openacs-4/packages/ecommerce/tcl/ecommerce-procs-oracle.xql	26 May 2002 04:36:49 -0000	1.5
@@ -1,102 +1,84 @@
 <?xml version="1.0"?>
 
 <queryset>
-   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+  <rdbms>
+    <type>oracle</type>
+    <version>8.1.6</version>
+  </rdbms>
 
-<fullquery name="ec_url_mem.ec_mountpoint">      
-      <querytext>
-      
-            select site_node.url(s.node_id)
-              from site_nodes s, apm_packages a
-             where s.object_id = a.package_id
-               and a.package_key = 'ecommerce'
-        
-      </querytext>
-</fullquery>
+  <fullquery name="ec_url_mem.ec_mountpoint">      
+    <querytext>
+      select site_node.url(s.node_id)
+      from site_nodes s, apm_packages a
+      where s.object_id = a.package_id
+      and a.package_key = 'ecommerce'
+    </querytext>
+  </fullquery>
 
- 
-<fullquery name="ec_package_url_lookup_mem.ec_mountpoint">      
-      <querytext>
-      
-            select site_node.url(s.node_id)
-              from site_nodes s, apm_packages a
-             where s.object_id = a.package_id
-               and a.package_key = '$package_key'
-        
-      </querytext>
-</fullquery>
+  <fullquery name="ec_package_url_lookup_mem.ec_mountpoint">      
+    <querytext>
+      select site_node.url(s.node_id)
+      from site_nodes s, apm_packages a
+      where s.object_id = a.package_id
+      and a.package_key = '$package_key'
+    </querytext>
+  </fullquery>
 
- 
-<fullquery name="ec_customer_comments.product_comment_info_select">      
-      <querytext>
-      
-	select c.one_line_summary,
-	       c.rating,
-	       c.user_comment,
- 	       to_char(c.last_modified,'Day Month DD, YYYY') as last_modified_pretty,
-	       u.email,
-	       u.user_id
-	  from ec_product_comments c,
-	       cc_users u
-	 where c.user_id = u.user_id
-	   and c.product_id = :product_id
-	   $end_of_comment_query
-    
-      </querytext>
-</fullquery>
+  <fullquery name="ec_customer_comments.product_comment_info_select">      
+    <querytext>
+      select c.one_line_summary,
+      c.rating,
+      c.user_comment,
+      to_char(c.last_modified,'Day Month DD, YYYY') as last_modified_pretty,
+      u.email,
+      u.user_id
+      from ec_product_comments c,
+      cc_users u
+      where c.user_id = u.user_id
+      and c.product_id = :product_id
+      $end_of_comment_query
+    </querytext>
+  </fullquery>
 
- 
-<fullquery name="ec_add_to_cart_link.get_product_info_1">      
-      <querytext>
-      
-	select decode(sign(sysdate-available_date),1,1,null,1,0) as available_p,
-               color_list, size_list, style_list, no_shipping_avail_p
-          from ec_products
-         where product_id = :product_id
-    
-      </querytext>
-</fullquery>
+  <fullquery name="ec_add_to_cart_link.get_product_info_1">      
+    <querytext>
+      select decode(sign(sysdate-available_date),1,1,null,1,0) as available_p,
+      color_list, size_list, style_list, no_shipping_avail_p
+      from ec_products
+      where product_id = :product_id
+    </querytext>
+  </fullquery>
 
- 
-<fullquery name="ec_add_to_cart_link.available_date_select">      
-      <querytext>
-      
-        select to_char(available_date,'Month DD, YYYY') available_date
-          from ec_products
-         where product_id = :product_id
-        
-      </querytext>
-</fullquery>
+  <fullquery name="ec_add_to_cart_link.available_date_select">      
+    <querytext>
+      select to_char(available_date,'Month DD, YYYY') available_date
+      from ec_products
+      where product_id = :product_id
+    </querytext>
+  </fullquery>
 
- 
-<fullquery name="ec_order_summary_for_customer.order_info_select">      
-      <querytext>
-      
-	select eco.confirmed_date, eco.creditcard_id, eco.shipping_method,
-	       u.email,
-	       eca.line1, eca.line2, eca.city, eca.usps_abbrev, eca.zip_code, eca.country_code,
-	       eca.full_state_name, eca.attn, eca.phone, eca.phone_time
-	  from ec_orders eco,
-	       cc_users u,
-	       ec_addresses eca
-	 where eco.order_id = :order_id
-	       and eco.user_id = u.user_id(+)
-	       and eco.shipping_address = eca.address_id(+)
-    
-      </querytext>
-</fullquery>
+  <fullquery name="ec_order_summary_for_customer.order_info_select">      
+    <querytext>
+      select eco.confirmed_date, eco.creditcard_id, eco.shipping_method,
+      u.email,
+      eca.line1, eca.line2, eca.city, eca.usps_abbrev, eca.zip_code, eca.country_code,
+      eca.full_state_name, eca.attn, eca.phone, eca.phone_time
+      from ec_orders eco,
+      cc_users u,
+      ec_addresses eca
+      where eco.order_id = :order_id
+      and eco.user_id = u.user_id(+)
+      and eco.shipping_address = eca.address_id(+)
+    </querytext>
+  </fullquery>
 
- 
-<fullquery name="ec_create_new_session_if_necessary.insert_user_session_sql">      
-      <querytext>
-      
-                    insert into ec_user_sessions
-                    (user_session_id, ip_address, start_time, http_user_agent)
-                    values
-                    (:user_session_id, :ip_address , sysdate, :http_user_agent)
-                
-      </querytext>
-</fullquery>
+  <fullquery name="ec_create_new_session_if_necessary.insert_user_session_sql">      
+    <querytext>
+      insert into ec_user_sessions
+      (user_session_id, ip_address, start_time, http_user_agent)
+      values
+      (:user_session_id, :ip_address , sysdate, :http_user_agent)
+    </querytext>
+  </fullquery>
 
- 
 </queryset>