Index: openacs-4/packages/forums/tcl/forums-callback-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/tcl/Attic/forums-callback-procs-oracle.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/forums/tcl/forums-callback-procs-oracle.xql	28 Jan 2006 15:39:03 -0000	1.1
@@ -0,0 +1,44 @@
+<?xml version="1.0"?>
+<!DOCTYPE queryset PUBLIC "-//OpenACS//DTD XQL 1.0//EN"
+"http://www.thecodemill.biz/repository/xql.dtd">
+<!--  -->
+<!-- @author Dave Bauer (dave@thedesignexperience.org) -->
+<!-- @creation-date 2006-01-28 -->
+<!-- @arch-tag: 33e3dcb8-30e3-445e-a6f7-7fc8e00c2301 -->
+<!-- @cvs-id $Id: forums-callback-procs-oracle.xql,v 1.1 2006/01/28 15:39:03 daveb Exp $ -->
+
+<queryset>
+
+    <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+
+    <fullquery name="callback::search::url::impl::forums_message.select_forums_package_url">
+        <querytext>
+            select site_node.url(min(node_id))
+            from site_nodes
+            where object_id = (select package_id
+                               from forums_forums
+                               where forums_forums.forum_id = :forum_id)
+        </querytext>
+    </fullquery>
+
+    <fullquery name="callback::search::url::impl::forums_forum.select_forums_package_url">
+        <querytext>
+            select site_node.url(min(node_id))
+            from site_nodes
+            where object_id = (select package_id
+                               from forums_forums
+                               where forums_forums.forum_id = :forum_id)
+        </querytext>
+    </fullquery>
+
+    <fullquery name="callback::search::datasource::impl::forums_message.messages">
+      <querytext>
+        select subject, content, format
+        from forums_messages
+        where message_id=:message_id 
+-- lets just get the message instead of the whole thread
+-- replace with a connect by
+      </querytext>
+    </fullquery>
+
+</queryset>
Index: openacs-4/packages/forums/tcl/forums-callback-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/tcl/Attic/forums-callback-procs-postgresql.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/forums/tcl/forums-callback-procs-postgresql.xql	28 Jan 2006 15:39:03 -0000	1.1
@@ -0,0 +1,44 @@
+<?xml version="1.0"?>
+<!DOCTYPE queryset PUBLIC "-//OpenACS//DTD XQL 1.0//EN"
+"http://www.thecodemill.biz/repository/xql.dtd">
+<!--  -->
+<!-- @author Dave Bauer (dave@thedesignexperience.org) -->
+<!-- @creation-date 2006-01-28 -->
+<!-- @arch-tag: 33e3dcb8-30e3-445e-a6f7-7fc8e00c2301 -->
+<!-- @cvs-id $Id: forums-callback-procs-postgresql.xql,v 1.1 2006/01/28 15:39:03 daveb Exp $ -->
+
+<queryset>
+
+    <rdbms><type>postgresql</type><version>7.4</version></rdbms>
+
+    <fullquery name="callback::search::url::impl::forums_message.select_forums_package_url">
+        <querytext>
+            select site_node__url(min(node_id))
+            from site_nodes
+            where object_id = (select package_id
+                               from forums_forums
+                               where forums_forums.forum_id = :forum_id)
+        </querytext>
+    </fullquery>
+
+    <fullquery name="callback::search::url::impl::forums_forum.select_forums_package_url">
+        <querytext>
+            select site_node__url(min(node_id))
+            from site_nodes
+            where object_id = (select package_id
+                               from forums_forums
+                               where forums_forums.forum_id = :forum_id)
+        </querytext>
+    </fullquery>
+
+    <fullquery name="callback::search::datasource::impl::forums_message.messages">
+      <querytext>
+        select subject, content, format
+        from forums_messages
+        where message_id=:message_id 
+-- lets just get the message instead of the whole thread
+-- replace with a connect by
+      </querytext>
+    </fullquery>
+
+</queryset>