Index: openacs-4/packages/chat/tcl/chat-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/chat/tcl/Attic/chat-procs-oracle.xql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/chat/tcl/chat-procs-oracle.xql	10 Apr 2006 11:53:20 -0000	1.1.2.1
+++ openacs-4/packages/chat/tcl/chat-procs-oracle.xql	11 Apr 2006 07:12:46 -0000	1.1.2.2
@@ -220,7 +220,7 @@
 	    chat_transcript.edit(
 	        transcript_id => :transcript_id,
 	        pretty_name   => :pretty_name,
-                contents      => :empty_clob(),
+		contents      => empty_clob(),
                 description   => :description);
 	    end;
       </querytext>
Index: openacs-4/packages/chat/tcl/chat-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/chat/tcl/chat-procs.tcl,v
diff -u -r1.5.2.2 -r1.5.2.3
--- openacs-4/packages/chat/tcl/chat-procs.tcl	7 Apr 2006 16:59:52 -0000	1.5.2.2
+++ openacs-4/packages/chat/tcl/chat-procs.tcl	11 Apr 2006 07:12:46 -0000	1.5.2.3
@@ -435,7 +435,10 @@
 
     db_transaction {
         set transcript_id [db_exec_plsql create_transcript {}]
-        db_exec_plsql grant_permission {}
+	if { $transcript_id ne 0 } {
+	    db_dml update_contents {}
+	    db_exec_plsql grant_permission {}
+	}
     }
 
     return $transcript_id
@@ -459,6 +462,7 @@
     Edit chat transcript.
 } {
     db_exec_plsql edit_transcript {}
+    db_dml update_contents {}
 }
 
 ad_proc -public chat_room_get {
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/chat/tcl/chat-procs.xql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: openacs-4/packages/chat/www/transcript-new-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/chat/www/transcript-new-oracle.xql,v
diff -u -r1.1 -r1.1.2.1
--- openacs-4/packages/chat/www/transcript-new-oracle.xql	14 Mar 2006 12:16:09 -0000	1.1
+++ openacs-4/packages/chat/www/transcript-new-oracle.xql	11 Apr 2006 07:12:46 -0000	1.1.2.1
@@ -5,13 +5,12 @@
 
 <fullquery name="get_archives_messages">
   <querytext>
-    select msg, person.name(creation_user) as name
+    select msg, creation_user, to_char(creation_date, 'DD.MM.YYYY hh24:mi:ss') as creation_date
     from chat_msgs
     where room_id = :room_id
           and msg is not null
-    order by msg_id
+    order by creation_date
   </querytext>
 </fullquery>
 
-
 </queryset>