Index: openacs-4/packages/faq-portlet/www/faq-portlet-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/faq-portlet/www/Attic/faq-portlet-oracle.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/faq-portlet/www/faq-portlet-oracle.xql	13 Mar 2002 22:00:45 -0000	1.2
+++ openacs-4/packages/faq-portlet/www/faq-portlet-oracle.xql	20 Mar 2002 20:08:12 -0000	1.3
@@ -5,11 +5,10 @@
 
 <fullquery name="faqs_select">
     <querytext>
-      select f.faq_id, f.faq_name, entry_id, question
-      from acs_objects o, faqs f, faq_q_and_as qa
+      select f.faq_id, f.faq_name
+      from acs_objects o, faqs f
       where object_id = f.faq_id
       and context_id = :package_id
-      and qa.faq_id(+) = f.faq_id
     </querytext>
 </fullquery>
 
Index: openacs-4/packages/faq-portlet/www/faq-portlet.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/faq-portlet/www/faq-portlet.tcl,v
diff -u -r1.8 -r1.9
--- openacs-4/packages/faq-portlet/www/faq-portlet.tcl	18 Mar 2002 05:05:04 -0000	1.8
+++ openacs-4/packages/faq-portlet/www/faq-portlet.tcl	20 Mar 2002 20:08:12 -0000	1.9
@@ -62,8 +62,16 @@
     
 } else {
     # i'm at /dotlrn, so have the table UI, hack
+
+    #
+    # this seems broken, but it was working ystr - aks 3/18 
+    #
+
+
+
     set one_instance_p 1
-    set data "<table border=\"0\" bgcolor=\"white\" cellpadding=\"2\" cellspacing=\"3\" width=\"100%\">
+    set data ""
+    set data_start "<table border=\"0\" bgcolor=\"white\" cellpadding=\"2\" cellspacing=\"3\" width=\"100%\">
     <tr>
                 <td><strong>Name</strong></td>
                 <td><strong>Group</strong></td>
@@ -91,8 +99,13 @@
         }
     }
 
-    append data "</table>"
+    set data_end "</table>"
 
+    if {$count != 0} {
+        append $data_start $data $data_end
+    }
+
+    
 }
 
 # portlets shouldn't disappear anymore (ben)