Question

[Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式

ASP代码set savebbs=conn.execute("insert into student (username,sex,bornfrom,byear,bmonth,bday,mobile,e_mail,yuanxi,politics,addr,firstdesire,seconddesire,question,question1,question2)values("&username&","&sex&","&bornfrom&","&byear&","&bmonth&",,"&bday&","&mobile&","&e_mail&","&yuanxi&","&politics&","&addr&","&firstdesire&","&seconddesire&","&question&","&question1&","&question2&")")%>
求问，哪里代码错了~

Answer 1

字符型需要加引号，values("&username&","&sex&","&……)
改成：value(" & "'" & username & "','" & sex & "'," & byear……
也就是说所有字符型的插入应该是单引号+变量+单引号

追问

改成values('" & username & "','" & sex & "','" & bornfrom...........
提示[Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。
还是这行数据的问题

追答

建议你一小段一小段测试，比如先测：
set savebbs=conn.execute("insert into student (username) values('"& username &"')")%>
如果能通过，再逐渐加上其它字段
set savebbs=conn.execute("insert into student (username,sex)values('"&username&"','"&sex & "')")%>
我不知道你的sex是定义的字符型还是布尔型，这里权当它是字符型

Answer 2

Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "Select * From student",1,2
rs.AddNew
rs("username")=username
rs("sex")=sex
rs("bornfrom")=bornfrom
rs("byear")=byear
rs("bmonth")=bmonth
rs("bday")=bday
rs("mobile")=mobile
rs("e_mail")=e_mail
rs("yuanxi")=yuanxi
rs("politics")=politics
rs("addr")=addr
rs("firstdesire")=firstdesire
rs("seconddesire")=seconddesire
rs("question")=question
rs("question1")=question1
rs("question2")=question2
rs.update

不管新手老手，这样写不是更清晰？ 你原来的有俩问题：
1：字符型值缺少单引号；2：笔误，有俩连续的逗号