postgresql7.3 select content_revision__get_content(et.revision_id) as content, et.title, et.item_id, et.mime_type, crr.content_length, cri.storage_type from evaluation_tasksi et, cr_items cri, cr_revisions crr where et.task_id = :task_id and crr.revision_id = et.task_id and et.item_id = cri.item_id select to_timestamp('[template::util::date::get_property linear_date $due_date]','YYYY MM DD HH24 MI SS') update cr_revisions set lob = [set __lob_id [db_string get_lob_id "select empty_lob()"]] where revision_id = :revision_id update cr_revisions set content = :url where revision_id = :revision_id update cr_items set storage_type = 'text' where item_id = :item_id select content_revision__content_copy(:task_id,:revision_id) update cr_revisions set content = :file_name, mime_type = :mime_type, content_length = :content_length where revision_id = :revision_id select count(*) from dotlrn_communities_all, dotlrn_member_rels_approved, dotlrn_classes where dotlrn_communities_all.community_id = dotlrn_member_rels_approved.community_id and dotlrn_communities_all.community_type = dotlrn_classes.class_key and dotlrn_member_rels_approved.user_id = :user_id and acs_permission__permission_p(dotlrn_communities_all.community_id, :user_id, 'admin') = true and dotlrn_communities_all.community_id <> [dotlrn_community::get_community_id]