Survey 261 en gid sid group_name group_order description language randomization_group grelevance qid parent_qid sid gid type title question preg help other mandatory question_order language scale_id same_default relevance modulename <![CDATA[Q1]]> qid parent_qid sid gid type title question preg help other mandatory question_order language scale_id same_default relevance modulename <![CDATA[A1]]> <![CDATA[A2]]> <![CDATA[A3]]> <![CDATA[A4]]> <![CDATA[A5]]> <![CDATA[A6]]> qid attribute value language sid admin expires startdate adminemail anonymized faxto format savetimings template language additional_languages datestamp usecookie allowregister allowsave autonumber_start autoredirect allowprev printanswers ipaddr refurl publicstatistics publicgraphs listpublic htmlemail sendconfirmation tokenanswerspersistence assessments usecaptcha usetokens bounce_email attributedescriptions emailresponseto emailnotificationto tokenlength showxquestions showgroupinfo shownoanswer showqnumcode bouncetime bounceprocessing bounceaccounttype bounceaccounthost bounceaccountpass bounceaccountencryption bounceaccountuser showwelcome showprogress questionindex navigationdelay nokeyboard alloweditaftercompletion googleanalyticsstyle googleanalyticsapikey surveyls_survey_id surveyls_language surveyls_title surveyls_description surveyls_welcometext surveyls_endtext surveyls_url surveyls_urldescription surveyls_email_invite_subj surveyls_email_invite surveyls_email_remind_subj surveyls_email_remind surveyls_email_register_subj surveyls_email_register surveyls_email_confirm_subj surveyls_email_confirm surveyls_dateformat surveyls_attributecaptions email_admin_notification_subj email_admin_notification email_admin_responses_subj email_admin_responses surveyls_numberformat attachments There is only one question in this survey and it's a multi choice (multi enum) question.

 

It has 6 answer options:

 

1. First answer

2. Second answer

3. Third answer

4. Fourth answer

5. Fifth answer

6. None of the above

 

The 2. and 4. answer are hidden.

 

If you choose the exlucive option the following should happend in the database - the entries will be recorded in the survey_{SURVEY_ID} table with the following values:

{SRURVEY_ID}X{GROUP_ID}X{QUESTION_ID}A1 should be blank ("") since this answer is shown.

{SRURVEY_ID}X{GROUP_ID}X{QUESTION_ID}A2 should be NULL since this answer is hidden.

{SRURVEY_ID}X{GROUP_ID}X{QUESTION_ID}A3 should be blank ("") since this answer is shown.

{SRURVEY_ID}X{GROUP_ID}X{QUESTION_ID}A4 should be NULL since this answer is hidden.

{SRURVEY_ID}X{GROUP_ID}X{QUESTION_ID}A5 should be blank ("") since this answer is shown.

{SRURVEY_ID}X{GROUP_ID}X{QUESTION_ID}A6 should be "Y" since this answer is checked.

 

The problem is with the A1, A3 and A5 answers, instead of blank "" they get the NULL value in the database and there is no way to determine which options did the user get to choose from.

 

 

]]>
you have been invited to participate in a survey.

The survey is titled:
"{SURVEYNAME}"

"{SURVEYDESCRIPTION}"

To participate, please click on the link below.

Sincerely,

{ADMINNAME} ({ADMINEMAIL})

----------------------------------------------
Click here to do the survey:
{SURVEYURL}

If you do not want to participate in this survey and don't want to receive any more invitations please click the following link:
{OPTOUTURL}

If you are blacklisted but want to participate in this survey and want to receive invitations please click the following link:
{OPTINURL}]]>
Recently we invited you to participate in a survey.

We note that you have not yet completed the survey, and wish to remind you that the survey is still available should you wish to take part.

The survey is titled:
"{SURVEYNAME}"

"{SURVEYDESCRIPTION}"

To participate, please click on the link below.

Sincerely,

{ADMINNAME} ({ADMINEMAIL})

----------------------------------------------
Click here to do the survey:
{SURVEYURL}

If you do not want to participate in this survey and don't want to receive any more invitations please click the following link:
{OPTOUTURL}]]>
You, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}.

To complete this survey, click on the following URL:

{SURVEYURL}

If you have any questions about this survey, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}.]]>
this email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating.

If you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}.

Sincerely,

{ADMINNAME}]]>
A new response was submitted for your survey '{SURVEYNAME}'.

Click the following link to reload the survey:
{RELOADURL}

Click the following link to see the individual response:
{VIEWRESPONSEURL}

Click the following link to edit the individual response:
{EDITRESPONSEURL}

View statistics by clicking here:
{STATISTICSURL}]]>
A new response was submitted for your survey '{SURVEYNAME}'.

Click the following link to reload the survey:
{RELOADURL}

Click the following link to see the individual response:
{VIEWRESPONSEURL}

Click the following link to edit the individual response:
{EDITRESPONSEURL}

View statistics by clicking here:
{STATISTICSURL}


The following answers were given by the participant:
{ANSWERTABLE}]]>