Index: openacs-4/packages/ecommerce/www/product-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/product-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ecommerce/www/product-oracle.xql	10 Jul 2001 20:42:02 -0000	1.1
+++ openacs-4/packages/ecommerce/www/product-oracle.xql	26 May 2002 04:36:50 -0000	1.2
@@ -1,38 +1,33 @@
 <?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="get_ec_product_info">      
-      <querytext>
-      
-select *
-  from ec_products p, ec_custom_product_field_values v
- where p.product_id = :product_id
-   and p.product_id = v.product_id(+)
+  <fullquery name="get_ec_product_info">      
+    <querytext>
+      select *
+      from ec_products p, ec_custom_product_field_values v
+      where p.product_id = :product_id
+      and p.product_id = v.product_id(+)
+    </querytext>
+  </fullquery>
 
-      </querytext>
-</fullquery>
-
- 
-<fullquery name="find_a_good_category">      
-      <querytext>
-      
-    select * from 
-        (select category_id,
-               (select count(*)
-                  from ec_subcategories s
-                 where s.category_id = m.category_id) subcount,
-               (select count(*)
-                  from ec_subsubcategories ss
-                 where ss.subcategory_id = m.category_id) subsubcount
+  <fullquery name="find_a_good_category">      
+    <querytext>
+      select * 
+      from (select category_id, (select count(*)
+              from ec_subcategories s
+              where s.category_id = m.category_id) subcount, (select count(*)
+              from ec_subsubcategories ss
+              where ss.subcategory_id = m.category_id) subsubcount
           from ec_category_product_map m
-         where product_id = :product_id
-      order by subcount, subsubcount, category_id)
-    where rownum = 1
+          where product_id = :product_id
+          order by subcount, subsubcount, category_id)
+      where rownum = 1
+    </querytext>
+  </fullquery>
 
-      </querytext>
-</fullquery>
-
- 
 </queryset>