macwiz
12-06-2008, 06:57 PM
Can someone please help me fix this? When I submit the from the previous page, I get this message:
A scalar value of type java.lang.String cannot be assigned to a 2-dimensional ColdFusion array.
The code included is of the page that the submit button from the previous page goes to.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<cfscript>
function getScore(Form)
{
var score = 0;
var currElt = 0;
var currSelection = 0;
var numQues = 2;
var numChoi = 3;
var answers = ARRAYNEW(3);
answers[0] = "B";
answers[1] = "A";
for (i=0; i<numQues; i++) {
currElt = i*numChoi;
for (j=0; j<numChoi; j++) {
currSelection = Form.elements[currElt + j];
if (currSelection.checked) {
if (currSelection.value == answers[i]) {
score++;
break;
}
}
}
}
score = Math.round(score/numQues*100);
return score;
}
</cfscript>
<cfquery name="AddData" datasource="AITE_Assessment">
INSERT INTO dbo.[Assessment] (MC_score) VALUES (#getScore(form)#) WHERE name=URL.name
</cfquery>
<body>
</body>
</html>
A scalar value of type java.lang.String cannot be assigned to a 2-dimensional ColdFusion array.
The code included is of the page that the submit button from the previous page goes to.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<cfscript>
function getScore(Form)
{
var score = 0;
var currElt = 0;
var currSelection = 0;
var numQues = 2;
var numChoi = 3;
var answers = ARRAYNEW(3);
answers[0] = "B";
answers[1] = "A";
for (i=0; i<numQues; i++) {
currElt = i*numChoi;
for (j=0; j<numChoi; j++) {
currSelection = Form.elements[currElt + j];
if (currSelection.checked) {
if (currSelection.value == answers[i]) {
score++;
break;
}
}
}
}
score = Math.round(score/numQues*100);
return score;
}
</cfscript>
<cfquery name="AddData" datasource="AITE_Assessment">
INSERT INTO dbo.[Assessment] (MC_score) VALUES (#getScore(form)#) WHERE name=URL.name
</cfquery>
<body>
</body>
</html>