I'm now at my wits end on this-

A question on a test has 2 correct answers, "ans_b" and "ans_c".

In the DB, the "ans_correct" field contains both values, comma
separated, (ans_b, ans_c).

The test question has three choices, and is set up:

<li><input type="checkbox" name="q01_ch01" value="ans_a">#ans_a#</li>
<li><input type="checkbox" name="q01_ch02" value="ans_b">#ans_b#</li>
<li><input type="checkbox" name="q01_ch03" value="ans_c">#ans_c#</li>
</ol>



Please reveal how you would code the action page that tallies the
correct answers for multiple checkbox responses!?

For answers in the test that have one correct answer, radio buttons were

used. Processing those are easy:

<CFSET num_correct =0>

<cfquery datasource="somedata" name="get_03">
SELECT quest_ID, ans_correct
FROM sometable
WHERE quest_ID = 3
</cfquery>

<cfoutput query="get_03">
<cfif #form.ans_03# eq #ans_correct#>
<CFSET num_correct = num_correct +1>
<cfelse><CFSET 'num_correct' = num_correct +0>
</cfif></cfoutput>

There are other ways to do this too?

Thanks-