Index: openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs-oracle.xql	10 Jul 2001 20:38:43 -0000	1.1
+++ openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs-oracle.xql	18 Jul 2001 00:03:07 -0000	1.2
@@ -3,18 +3,31 @@
 <queryset>
    <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
-<fullquery name="ec_creditcard_widget.date_widget_select">      
+<fullquery name="ec_date_widget.date_widget_select">      
       <querytext>
       select to_char(sysdate, 'YYYY-MM-DD') from dual
       </querytext>
 </fullquery>
 
  
-<fullquery name="ec_creditcard_widget.time_widget_select">      
+<fullquery name="ec_time_widget.time_widget_select">      
       <querytext>
       select to_char(sysdate, 'HH24:MI:SS') from dual
       </querytext>
 </fullquery>
 
+<fullquery name="ec_category_widget.get_category_info_joined_w_children">
+      <querytext>
+
+    select c.category_id, c.category_name,
+           s.subcategory_id, s.subcategory_name,
+           ss.subsubcategory_id, ss.subsubcategory_name
+      from ec_categories c, ec_subcategories s, ec_subsubcategories ss
+     where c.category_id = s.category_id (+)
+       and s.subcategory_id = ss.subcategory_id (+)
+  order by c.sort_key, s.sort_key, ss.sort_key
+
+      </querytext>
+</fullquery>
  
 </queryset>
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.1 -r1.2
--- openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs-postgresql.xql	10 Jul 2001 20:38:43 -0000	1.1
+++ openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs-postgresql.xql	18 Jul 2001 00:03:07 -0000	1.2
@@ -3,18 +3,32 @@
 <queryset>
    <rdbms><type>postgresql</type><version>7.1</version></rdbms>
 
-<fullquery name="ec_creditcard_widget.date_widget_select">      
+<fullquery name="ec_date_widget.date_widget_select">      
       <querytext>
       select to_char(current_timestamp, 'YYYY-MM-DD') 
       </querytext>
 </fullquery>
 
  
-<fullquery name="ec_creditcard_widget.time_widget_select">      
+<fullquery name="ec_time_widget.time_widget_select">      
       <querytext>
       select to_char(current_timestamp, 'HH24:MI:SS') 
       </querytext>
 </fullquery>
 
+
+<fullquery name="ec_category_widget.get_category_info_joined_w_children">
+      <querytext>
+
+    select c.category_id, c.category_name,
+           s.subcategory_id, s.subcategory_name,
+           ss.subsubcategory_id, ss.subsubcategory_name
+      from ec_categories c
+	   LEFT JOIN ec_subcategories s using (category_id)
+	   LEFT JOIN ec_subsubcategories ss on (s.subcategory_id = ss.subcategory_id)
+  order by c.sort_key, s.sort_key, ss.sort_key
+
+      </querytext>
+</fullquery>
  
 </queryset>
Index: openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs.tcl,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs.tcl	20 Apr 2001 20:51:13 -0000	1.1
+++ openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs.tcl	18 Jul 2001 00:03:07 -0000	1.2
@@ -239,7 +239,7 @@
 
 # displays all categories, subcategories, and subsubcategories
 # default is a list of all the items you want selected
-proc ec_category_widget { {multiple_p "f"} {default ""} {allow_null_categorization "f"}} {
+proc_doc ec_category_widget { {multiple_p "f"} {default ""} {allow_null_categorization "f"}} { displays all categories, subcategories, and subsubcategories, default is a list of all the items you want selected } {
     if { $multiple_p == "f" } {
 	set to_return "<select name=categorization>\n"
     } else {