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.5 -r1.6
--- openacs-4/packages/ecommerce/tcl/ecommerce-procs-oracle.xql	26 May 2002 04:36:49 -0000	1.5
+++ openacs-4/packages/ecommerce/tcl/ecommerce-procs-oracle.xql	12 Sep 2002 22:10:27 -0000	1.6
@@ -6,6 +6,14 @@
     <version>8.1.6</version>
   </rdbms>
 
+  <fullquery name="ec_combocategory_widget.get_combocategories">      
+    <querytext>
+      select c.category_id, s.subcategory_id, category_name, subcategory_name 
+      from ec_categories c, ec_subcategories s
+      where c.category_id(+)=s.category_id
+    </querytext>
+  </fullquery>
+
   <fullquery name="ec_url_mem.ec_mountpoint">      
     <querytext>
       select site_node.url(s.node_id)
@@ -72,12 +80,12 @@
     </querytext>
   </fullquery>
 
-  <fullquery name="ec_create_new_session_if_necessary.insert_user_session_sql">      
+  <fullquery name="ec_create_new_session_if_necessary.insert_user_session">      
     <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)
+      (:user_session_id, :ip_address, sysdate, :http_user_agent)
     </querytext>
   </fullquery>
 
Index: openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs-postgresql.xql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs-postgresql.xql	26 May 2002 04:36:50 -0000	1.5
+++ openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs-postgresql.xql	12 Sep 2002 22:10:27 -0000	1.6
@@ -6,6 +6,14 @@
     <version>7.1</version>
   </rdbms>
 
+  <fullquery name="ec_combocategory_widget.get_combocategories">      
+    <querytext>
+      select c.category_id, s.subcategory_id, category_name, subcategory_name 
+      from ec_categories c left
+      outer join ec_subcategories s using (category_id)
+    </querytext>
+  </fullquery>
+  
   <partialquery name="ec_gift_certificate_expires_widget.now">
     <querytext>
       current_timestamp
Index: openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs.xql	26 May 2002 04:36:50 -0000	1.3
+++ openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs.xql	12 Sep 2002 22:10:27 -0000	1.4
@@ -10,14 +10,6 @@
     </querytext>
   </fullquery>
 
-  <fullquery name="ec_combocategory_widget.get_combocategories">      
-    <querytext>
-      select c.category_id, s.subcategory_id, category_name, subcategory_name 
-      from ec_categories c left
-      outer join ec_subcategories s using (category_id)
-    </querytext>
-  </fullquery>
-  
   <fullquery name="ec_subcategory_widget.get_subcats_by_name">      
     <querytext>
       select subcategory_id, subcategory_name