postgresql7.1 select attributes.attribute_id, attribute_name, attributes.table_name, attribute_label, type_label, object_type as subtype, datatype, params.is_html, params.is_required, widget, param, coalesce( (select param_type from cm_attribute_widget_params where attribute_id = attributes.attribute_id and param_id = params.param_id), 'literal' ) as param_type, coalesce( (select param_source from cm_attribute_widget_params where attribute_id = attributes.attribute_id and param_id = params.param_id), 'onevalue' ) as param_source, coalesce( (select value from cm_attribute_widget_params where attribute_id = attributes.attribute_id and param_id = params.param_id), params.default_value ) as value from ( select aw.attribute_id, fwp.param, aw.widget, case when aw.is_required = 't' then 't' else fwp.is_required end as is_required, fwp.param_id, fwp.default_value, fwp.is_html from cm_form_widget_params fwp, cm_attribute_widgets aw where fwp.widget = aw.widget ) params, ( select attr.attribute_id, attribute_name, sort_order, attr.pretty_name as attribute_label, attr.datatype, types.object_type, types.pretty_name as type_label, tree_level, types.table_name from acs_attributes attr join ( select o2.object_type, o2.pretty_name, tree_level(o2.tree_sortkey) as tree_level, o2.table_name from ( SELECT * FROM acs_object_types WHERE object_type = :content_type ) o1, acs_object_types o2 where o2.object_type <> 'acs_object' AND o2.tree_sortkey <= o1.tree_sortkey AND o1.tree_sortkey between o2.tree_sortkey and tree_right(o2.tree_sortkey) ) types USING (object_type) ) attributes where attributes.attribute_id = params.attribute_id to_char($attribute_name, 'YYYY MM DD HH24 MI SS') as $attribute_name select content_item__get_latest_revision(:item_id) select coalesce(pretty_name,enum_value), enum_value from acs_enum_values where attribute_id = :attribute_id order by sort_order select content_revision__new(:title,:description,:mime_type,' ',content_symlink__resolve(:item_id),null,null) as revision_id select types.table_name, types.id_column, attr.attribute_name, attr.datatype from acs_attributes attr RIGHT OUTER JOIN ( select o2.object_type, o2.table_name, o2.id_column, tree_level(o2.tree_sortkey) as inherit_level from ( SELECT * FROM acs_object_types WHERE object_type = :content_type ) o1, acs_object_types o2 where o2.object_type <> 'acs_object' AND o2.object_type <> 'content_revision' AND o2.tree_sortkey <= o1.tree_sortkey AND o1.tree_sortkey between o2.tree_sortkey and tree_right(o2.tree_sortkey) ) types USING (object_type) order by types.inherit_level desc select types.table_name, types.id_column, attr.attribute_name, attr.datatype from acs_attributes attr right outer join ( select o2.object_type, o2.table_name, o2.id_column, tree_level(o2.tree_sortkey) as inherit_level from ( SELECT * FROM acs_object_types WHERE object_type = :content_type ) o1, acs_object_types o2 where object_type not in ($sql_exclusion) and o2.tree_sortkey <= o1.tree_sortkey and o1.tree_sortkey between o2.tree_sortkey and tree_right(o2.tree_sortkey) ) types USING (object_type) select content_item__new(varchar :name, :parent_id, :item_id, :locale, current_timestamp, null, null, null, 'content_item', :content_type, null, null, 'text/plain', null, null, :storage_type) update cr_revisions set content = :file_path, content_length = :file_size where revision_id = :revision_id update cr_revisions set content = '[DoubleApos [read [set __f [open $tmpfile r]]]][close $__f]', content_length = [file size $tmpfile] where revision_id = :revision_id update cr_revisions set lob = [set __lob_id [db_string new_lob "select empty_lob()"]], content_length = [file size $tmpfile] where revision_id = :revision_id update cr_revisions set content = '[set file_path [cr_create_content_file $item_id $revision_id $tmpfile]]', content_length = '[cr_file_size $file_path]' where revision_id = :revision_id update cr_revisions set content = '[DoubleApos [read [set __f [open $tmpfile r]]]][close $__f]', content_length = [file size $tmpfile] where revision_id = :revision_id update cr_revisions set lob = [set __lob_id [db_string new_lob "select empty_lob()"]], content_length = [file size $tmpfile] where revision_id = :revision_id to_date(:$name, 'YYYY MM DD HH24 MI SS') select relation_tag as label, relation_tag as value from cr_type_children c where content_item__is_subclass(:parent_type, c.parent_type) = 't' and content_item__is_subclass(:content_type, c.child_type) = 't' and content_item__is_valid_child(:parent_id, c.child_type) = 't' select content_item__get_title(:parent_id, 'f') to_char($attr, 'YYYY MM DD HH24 MI SS') as $attr select [join $args ","] from acs_attributes, ( select o2.object_type as ancestor, tree_level(o2.tree_sortkey) as type_order from ( SELECT * FROM acs_object_types WHERE object_type = :content_type ) o1, acs_object_types o2 where o2.tree_sortkey <= o1.tree_sortkey AND o1.tree_sortkey between o2.tree_sortkey and tree_right(o2.tree_sortkey) ) types where object_type = ancestor order by type_order desc, sort_order select coalesce(pretty_name,enum_value), enum_value from acs_enum_values where attribute_id = :attribute_id order by sort_order select content_item__get_latest_revision(:item_id) select content_revision__new( :title, :description, current_timestamp, :mime_type, null, :text, content_symlink__resolve(:item_id), :revision_id, current_timestamp, null, null) update cr_revisions set lob = [set __lob_id [db_string get_id "select empty_lob()"]] where revision_id = :revision_id select content_revision__content_copy (:revision_id_src, :revision_id_dest)