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]