Index: openacs-4/packages/survey/tcl/survey-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/survey/tcl/survey-procs.xql,v diff -u -r1.5 -r1.6 --- openacs-4/packages/survey/tcl/survey-procs.xql 13 Jan 2005 13:58:45 -0000 1.5 +++ openacs-4/packages/survey/tcl/survey-procs.xql 3 Sep 2024 15:37:54 -0000 1.6 @@ -1,7 +1,7 @@ - + select count(*) from dotlrn_member_rels_full where rel_type='dotlrn_member_rel' @@ -10,23 +10,23 @@ - + select min(section_id) as section_id from survey_sections where survey_id = :survey_id - + select survey_id from survey_sections where section_id = :section_id - + select s.*, o.creation_user, o.creation_date, p.first_names || ' ' || p.last_name as creator_name, @@ -42,7 +42,7 @@ - + select choice_id, @@ -59,7 +59,7 @@ - + select choice_id, @@ -76,7 +76,7 @@ - + select @@ -99,7 +99,7 @@ - + select choice_id, label from survey_question_choices @@ -109,7 +109,7 @@ - + select choice_id, label from survey_question_choices @@ -119,7 +119,7 @@ - + select * from survey_question_choices where question_id = :question_id @@ -129,7 +129,7 @@ - + select label from survey_question_choices, survey_question_responses @@ -142,22 +142,22 @@ - + select * from survey_questions where question_id=:question_id - + update survey_questions set question_text = :question_text where question_id = :new_question_id - + update survey_questions set sort_order = sort_order + 1 @@ -166,14 +166,14 @@ - + select * from survey_question_choices where question_id=:old_question_id - + insert into survey_question_choices (choice_id, question_id, label, numeric_value, sort_order) @@ -183,28 +183,28 @@ - + select survey_id from survey_responses where response_id=:response_id - + select count(*) from survey_responses_latest where survey_id=:survey_id - + select count(*) from party_approved_member_map where party_id=:segment_id - + select sort_order, question_text, question_id from survey_questions @@ -215,7 +215,7 @@ - + select survey_id, @@ -232,28 +232,28 @@ - + update survey_sections set description=:description where section_id=:new_section_id - + select section_id from survey_sections where survey_id=:survey_id - + select question_id from survey_questions where section_id in (select section_id from survey_sections where survey_id=:survey_id) - + select @@ -288,15 +288,15 @@ - + select presentation_options from survey_questions where question_id=:question_id - + select title from cr_revisions where revision_id=:attachment_answer