select 1 from survey_sections where section_id = :section_id
select question_id, question_text, abstract_data_type, presentation_type, required_p
from survey_questions
where section_id = :section_id
and active_p = 't'
order by sort_order
select question_id, question_text, abstract_data_type, presentation_type, required_p
from survey_questions
where section_id = :section_id
and active_p = 't'
order by sort_order
insert into survey_question_responses (response_id, question_id, choice_id)
values (:response_id, :question_id, :response_value)
insert into survey_question_responses (response_id, question_id, choice_id)
values (:response_id, :question_id, :response_value)
insert into survey_question_responses (response_id, question_id, varchar_answer)
values (:response_id, :question_id, :response_value)
insert into survey_question_responses (response_id, question_id, boolean_answer)
values (:response_id, :question_id, :response_value)
insert into survey_question_responses (response_id, question_id, number_answer)
values (:response_id, :question_id, :response_value)
insert into survey_question_responses (response_id, question_id, date_answer)
values (:response_id, :question_id, :response_value)
select type from survey_sections where section_id = :section_id
select name from survey_sections where section_id = :section_id
select variable_name, sum(score) as sum_of_scores
from survey_choice_scores, survey_question_responses, survey_variables
where survey_choice_scores.choice_id = survey_question_responses.choice_id
and survey_choice_scores.variable_id = survey_variables.variable_id
and survey_question_responses.response_id = :response_id
group by variable_name
select logic from survey_logic, survey_logic_surveys_map
where survey_logic.logic_id = survey_logic_surveys_map.logic_id
and section_id = :section_id
insert into survey_question_responses
(response_id, question_id, attachment_file)
values
(:response_id, :question_id, :revision_id)