select persons.first_names||' '||persons.last_name as party_name, persons.person_id from persons, dotlrn_member_rels_approved where dotlrn_member_rels_approved.community_id = :community_id and dotlrn_member_rels_approved.user_id = persons.person_id order by party_name select signature_p from messages_options where user_id = :owner_id select signature from messages_options where user_id = :owner_id select attachment_id, attachment_item_id from messages_attachments where msg_id = :msg_id update cr_revisions set content_length = :content_length where revision_id = :revision_id update cr_revisions set title = :title, mime_type = :mime_type, content_length = :content_length where revision_id = :revision_id