update acs_objects set last_modified = current_timestamp, modifying_user = :modifying_user, modifying_ip = :modifying_ip, title = :label where object_id = :symlink_id update cr_symlinks set target_id = :target_id, label = :label, description = :description where symlink_id = :symlink_id select label from cr_symlinks where symlink_id = :item_id select table_name from acs_object_types where object_type = :content_type select x.*, :item_id as item_id $text_sql, :content_type as content_type from cr_revisions r, ${table_name}x x where r.revision_id = :revision_id and x.revision_id = r.revision_id select mime_type from cr_content_mime_type_map where content_type = :content_type and lower(mime_type) like 'text/%' select m.mime_type, m.file_extension from cr_mime_types m, cr_revisions r where r.mime_type = m.mime_type and r.revision_id = :revision_id update acs_objects set last_modified = current_timestamp, modifying_user = :modifying_user, modifying_ip = :modifying_ip, title = :label where object_id = :extlink_id update cr_extlinks set url = :url, label = :label, description = :description where extlink_id = :extlink_id select label from cr_extlinks where extlink_id = :item_id