Index: openacs-4/packages/assessment/www/admin/item-edit-mc-choices.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/admin/Attic/item-edit-mc-choices.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/assessment/www/admin/item-edit-mc-choices.xql 8 Dec 2004 15:30:34 -0000 1.1 +++ openacs-4/packages/assessment/www/admin/item-edit-mc-choices.xql 7 Jan 2005 16:10:45 -0000 1.2 @@ -1,29 +1,38 @@ - + - select c.choice_id, r.title, c.correct_answer_p, c.feedback_text, - c.selected_p, c.percent_score - from as_item_choices c, cr_revisions r - where r.revision_id = c.choice_id - and c.mc_id = :mc_id - order by c.sort_order + update as_item_choices + set feedback_text = :feedback_text, + selected_p = :selected_p, + percent_score = :percent_score, + fixed_position = :fixed_position, + text_value = :answer_value + where choice_id = :choice_id - + update as_item_choices - set feedback_text = :feedback_text, - selected_p = :selected_p, - percent_score = :percent_score + set content_value = :content_rev_id where choice_id = :choice_id + + + + update as_item_choices + set content_value = null + where choice_id = :choice_id + + + +