postgresql7.1 select dtype_widget__register_form_widget ( :object_type, :dform, :attribute_name, :widget, :required_p, :create_form_p ); select dtype_widget__unregister_form_widget ( :object_type, :dform, :attribute_name, :delete_form_p ); select f.name as dform from dtype_form_elements fe, dtype_forms f, acs_attributes a where fe.form_id = f.form_id and a.attribute_id = fe.attribute_id and a.object_type = :object_type and a.attribute_name = :attribute_name select dtype_widget__set_param_value ( :object_type, :dform, :attribute_name, :param_name, :value, :type, :source ); select o2.object_type from acs_object_types o1, acs_object_types o2 where o1.object_type = :object_type and o2.tree_sortkey <= o1.tree_sortkey and o1.tree_sortkey between o2.tree_sortkey and tree_right(o2.tree_sortkey) order by tree_level(o2.tree_sortkey) desc select o2.object_type from acs_object_types o1, acs_object_types o2, acs_objects o where o.object_id = :object_id and o1.object_type = o.object_type and o2.tree_sortkey <= o1.tree_sortkey and o1.tree_sortkey between o2.tree_sortkey and tree_right(o2.tree_sortkey) order by tree_level(o2.tree_sortkey) desc select content_item__new(varchar :item_name, :item_parent_id, :item_item_id, :item_locale, now(), :item_creation_user, null, :item_creation_ip, 'content_item', :item_content_type, null, null, 'text/plain', null, null, :cr_storage) update cr_revisions set content = '[DoubleApos [read [set __f [open $file r]]]][close $__f]', content_length = [file size $file] where revision_id = :revision_id update cr_revisions set lob = [set __lob_id [db_string new_lob "select empty_lob()"]], content_length = [file size $file] where revision_id = :revision_id update cr_revisions set content = '[set file_path [cr_create_content_file $item_id $revision_id $file]]', content_length = '[cr_file_size $file_path]' where revision_id = :revision_id content_item__get_latest_revision(:item_id)