第一次用asp,请教!
徐蕴 2000-12-25 05:41:00 不知道应该在数据库版还是在asp中提问
这是我的一部分代码
<%
question="aaaa"
optionno=100
set connVB = server.createobject("ADODB.Connection")
connVB.open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.mappath(mBaseDir & "Messages.mdb")
connVB.execute("INSERT INTO Option (Option, QuestionID) SELECT '"& question & "' as a, " & optionno & " as b")
connVB.execute("INSERT INTO Question (Question,QuestionID) SELECT '"& question & "' as a, " & optionno & " as b")
%>
很简单的数据库,有三个表:Question(QuestionID(auto number, primary key),Question(text));
Opiton(OptionID(auto number,primary key),Option(text));
Answer(AnwerID(auto number,primary key), QuestionID, OptionID);
我准备将数据插入option表中,用了上面的那个语句,结果得到
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
而当我用同样的语句格式将数据插入question表中时(如上),完全正常.
请问我到底在那里出错了?多谢指教!!