update chat_transcripts set contents = :contents where transcript_id = :transcript_id update chat_transcripts set contents = :contents where transcript_id = :transcript_id select room_id from chat_rooms where archive_p = 't' and auto_flush_p = 't' 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 creation_date