Index: openacs-4/packages/forums/www/message-post-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/Attic/message-post-oracle.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/forums/www/message-post-oracle.xql	30 Jul 2002 22:27:28 -0000	1.1
@@ -0,0 +1,12 @@
+<?xml version="1.0"?>
+<queryset>
+    <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+
+    <fullquery name="messages_select">
+        <querytext>
+          select to_char(sysdate, 'Mon DD YYYY HH24:MI:SS') 
+          from dual
+        </querytext>
+    </fullquery>
+
+</queryset>
Index: openacs-4/packages/forums/www/message-post-postgres.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/Attic/message-post-postgres.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/forums/www/message-post-postgres.xql	30 Jul 2002 22:27:28 -0000	1.1
@@ -0,0 +1,18 @@
+<?xml version="1.0"?>
+<queryset>
+
+    <fullquery name="select_name">
+        <querytext>
+          select first_names || ' ' || last_name
+          from persons
+          where person_id = :user_id
+        </querytext>
+    </fullquery>
+
+    <fullquery name="messages_select">
+        <querytext>
+          select to_char(current_timestamp, 'Mon DD YYYY HH24:MI:SS') 
+        </querytext>
+    </fullquery>
+
+</queryset>
Index: openacs-4/packages/forums/www/message-post.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/message-post.tcl,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/forums/www/message-post.tcl	30 Jul 2002 22:04:59 -0000	1.9
+++ openacs-4/packages/forums/www/message-post.tcl	30 Jul 2002 22:27:28 -0000	1.10
@@ -98,8 +98,8 @@
         set message(subject) $subject
         set message(content) $content
         set message(user_id) $user_id
-        set message(user_name) [db_string select_name {select first_names || ' ' || last_name from persons where person_id = :user_id}]
-        set message(posting_date) [db_string select_date {select to_char(sysdate, 'Mon DD YYYY HH24:MI:SS') from dual}]
+        set message(user_name) [db_string select_name {}]
+        set message(posting_date) [db_string select_date {}]
 
         # Let's check if this person is subscribed to the forum
         # in case we might want to subscribe them to the thread
Fisheye: Tag 1.3 refers to a dead (removed) revision in file `openacs-4/packages/forums/www/message-preview-chunk.adp'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.3 refers to a dead (removed) revision in file `openacs-4/packages/forums/www/message-preview-chunk.tcl'.
Fisheye: No comparison available.  Pass `N' to diff?