"UPDATE traineeReport SET TWA_Attempted = Yes, TWA_Correct

= " & Session("CorrectAnswers") & ", TWA_Wrong = " & Session("WrongAnswers") & " WHERE

employeeNumber = " & Session("CurrentEmployee")


I am using the above SQL string in an ASP page. I am having a problem in that the above sets TWA_Attempted, TWA_Correct, TWA_Wrong correctly, but it sets these values for EVERY employeeNumber.

For some reason, it is not picking the correct employeeNumber.

WHY???