Index: openacs-4/packages/assessment/www/admin/action-select.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/admin/Attic/action-select.xql,v diff -u -N --- openacs-4/packages/assessment/www/admin/action-select.xql 28 Jan 2005 20:33:19 -0000 1.2 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,77 +0,0 @@ - - - - - - select name, action_id from as_actions - - - - - - select max(am.order_by) from as_action_map am,as_inter_item_checks c - where c.inter_item_check_id=am.inter_item_check_id and - c.section_id_from = :section_id and am.action_perform=:action_perform - - - - - - insert into as_action_map - (inter_item_check_id,action_id,order_by,user_message,action_perform) - values (:inter_item_check_id,:action_id,:order,:user_message,:action_perform) - - - - - - select count(inter_item_check_id) from as_action_map where inter_item_check_id=:inter_item_check_id - - - - - - select * from as_action_map where inter_item_check_id=:inter_item_check_id - - - - - - select action_p from as_inter_item_checks where inter_item_check_id=:inter_item_check_id - - - - - - select action_perform from as_action_map where inter_item_check_id=:inter_item_check_id - - - - - - update as_action_map set action_perform=:action_perform, action_id=:action_id, user_message=:user_message where inter_item_check_id=:inter_item_check_id - - - - - - - update as_action_map set action_perform=:action_perform, action_id=:action_id, user_message=:user_message,order_by=:order where inter_item_check_id=:inter_item_check_id - - - - - - delete from as_action_map where inter_item_check_id=:inter_item_check_id; - - - - - - delete from as_param_map where inter_item_check_id=:inter_item_check_id; - - - - - -