we are having problem in a online examwe're doing, it connects to the database to get questions answers and questionnaires with their id's:
Error Type:Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'tb_questions.idType = tb_questionnaires.id And tb_questions.idType ='
the statement in my program named "save.asp":
strSQL = " Select idtype, strQuestionnaire, tb_questions.id, strQuestion "
strSQL = strSQL & " From tb_questions, tb_questionnaires "
strSQL = strSQL & " Where tb_questions.idType = tb_questionnaires.id "
strSQL = strSQL & " And tb_questions.idType = " & request("txtOrder")
strSQL = strSQL & " Order by tb_questionnaires.id "
the other day it was working fine and then this morning it just became totally whacked!
pls... help! and by the way I am a newbie here...