Arrays And Radio/Check Options 1

[OrWolf]

I'm creating a survey and want to have the user input via check boxes or radio buttons. Since the number of answers vary, I was going to use an array to create the options. Below is the portion of the code applicable to what I want to use. However I'm completely stumped on how to populate the form options. Any suggestions on the syntx would be greatly appreciated.

aSQL="SELECT RA_SurveyAnswers.AnswerID, RA_SurveyAnswers.PossibleAnswer " & _
"FROM RA_SurveyAnswers WHERE (((RA_SurveyAnswers.RAS_ID)=" & iRASID & &quot)"

Set rs2 = objConnection.Execute(aSQL)

arrAnswerID = Array(rs2("AnswerID&quot)
arrAnswer = Array(rs2("PossibleAnswer&quot)

 

[LnOrS]

Hi,

There are diferences between radio buttons and check boxes!
Each radio-button control in the group should be given the same name. Only the selected radio button in the group generates a name/value pair in the submitted data. Radio buttons require an explicit value property.
(Check box) This element is represented by a number of check box controls, each of which has the same name. Each selected check box generates a separate name/value pair in the submitted data, even if this results in duplicate names. The default value for check boxes is on.
The following code is for radio buttons:

<%
  do until rs2.EOF
%>
<input type=radio name=Answer value=&quot;<% =rs2(&quot;AnswerID&quot;) %>&quot;><% =Server.HTMLEncode(rs2(&quot;PossibleAnswer&quot;)) %><br>
<%
    rs2.MoveNext
  loop
%>

Regards,
Luís Silva

 

[OrWolf]

Thanks for the help. It worked like a charm. However, know I'm wondering how I can extract the information input in the following ASP page to use in a SQL statement to feedback into a database. I tried using the following to reference it, but it came back with all null values. I tested each value seperately using test data and 2 of 5 have values.


aSQL="SELECT RA_SurveyAnswers.AnswerID " & _
"FROM RA_SurveyAnswers WHERE (((RA_SurveyAnswers.RAS_ID)=" & iRASID & &quot)"

Set rs2 = objConnection.Execute(aSQL)
Do While Not rs2.EOF
iAnswerID = rs2("AnswerID&quot
Answer = Request.Form("'"&iAnswerID&"'&quot
(SQL string here)
rs2.MoveNext
Loop

 

[LnOrS]

Hi again,

Sorry, I'm not really understanding what you really want, but if you used the same code I wrote you must use

Answer = Request.Form("Answer")

and not

Answer = Request.Form("'"&iAnswerID&"'")

as you did.
When you use Request.Form you must fill it with a variable name (input name, select name, etc) of the previous form.
Hope I've helped.

Regards,
Luís Silva

 

[OrWolf]

I used check boxes, so the survey page is dynamic. I'll have two to five or six possible answers per question. If I just refer to 'Answer' then I'll only end up with one . . . right?