Hi,
Does anyone know enough of classic asp and asp.net to convert this code from Classic asp to asp.net or vb.net for me?
SQlSre="SELECT Q.question, Q.answerType, C.Choice, C.isCorrect, CASE WHEN A.cid IS NULL THEN 0 ELSE 1 END " & _
" AS answer " & _
" & _FROM surveyquestions AS Q " & _
" & _INNER JOIN surveychoices AS C ON Q.qid = C.qid " & _
" & _LEFT JOIN surveyanswers AS A ON A.qid = C.qid AND A.cid = C.cid AND A.uid = 102 " & _
" & _ORDER BY Q.question,C.Choice " & _
SQL = "...above..."
Set RS = conn.Execute(SQL)
currentQ = RS("question")
totalScore = 0
qscore = 0
qcount = 0
Response.Write currentQ & "<ul>" ' simplified output
Do Until RS.EOF
q = RS("question")
choice = RS("choice")
isCorrect = RS("isCorrect")
answer = ...
Go to the complete details ...