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>