Index: openacs-4/packages/faq/www/index.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/faq/www/index.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/faq/www/index.xql	12 Mar 2007 02:33:54 -0000	1.1.2.1
@@ -0,0 +1,17 @@
+<?xml version="1.0"?>
+<queryset>
+
+<fullquery name="faq_select">      
+  <querytext>
+      
+    select faq_id, faq_name
+      from acs_objects o, faqs f
+      where object_id = faq_id
+        and context_id = :package_id     
+        and disabled_p = 'f'
+    order by faq_name
+
+  </querytext>
+</fullquery>
+
+</queryset>
Index: openacs-4/packages/faq/www/one-faq.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/faq/www/one-faq.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/faq/www/one-faq.xql	12 Mar 2007 02:33:54 -0000	1.1.2.1
@@ -0,0 +1,33 @@
+<?xml version="1.0"?>
+<queryset>
+
+<fullquery name="categorized_faq">      
+  <querytext>
+    select entry_id, faq_id, question, answer, sort_key
+    from faq_q_and_as qa, category_object_map com
+    where faq_id = :faq_id and
+	com.object_id = qa.entry_id and
+	com.category_id = :category_id
+    order by sort_key
+  </querytext>
+</fullquery>
+
+<fullquery name="uncategorized_faq">
+  <querytext>
+    select entry_id, faq_id, question, answer, sort_key
+    from faq_q_and_as
+    where faq_id = :faq_id
+    order by sort_key  
+  </querytext>
+</fullquery>
+
+<fullquery name="faq_categories">
+  <querytext>
+	select c.category_id as category_id, c.tree_id
+	from   categories c, category_tree_map ctm
+	where  ctm.tree_id = c.tree_id
+	and    ctm.object_id = :package_id
+  </querytext>
+</fullquery>
+
+</queryset>
Index: openacs-4/packages/faq/www/one-question.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/faq/www/one-question.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/faq/www/one-question.xql	12 Mar 2007 02:33:54 -0000	1.1.2.1
@@ -0,0 +1,13 @@
+<?xml version="1.0"?>
+<queryset>
+
+  <fullquery name="question_info">
+    <querytext>
+	select question, answer,faq_name, f.faq_id 
+        from faq_q_and_as qa, faqs f
+        where entry_id = :entry_id
+         and qa.faq_id = f.faq_id
+    </querytext>
+  </fullquery>
+
+</queryset>
\ No newline at end of file