UC知道INSERT INTO 语句的语法错误。哪个地方错了啊？？谢谢！！
来源：百度知道 编辑：UC知道 时间：2024/09/22 22:23:18
<%
set rst=conn.Execute("insert into dbq (name,phone,email,sex,content) values ('" & request.form("name") & "'," & request.form("phone") & ",'" & request.form("email") & "','" & request.form("sex") & "','" & request.form("content") & "')" )
%>
怎么还不可以啊？？
set rst=conn.Execute("insert into dbq (name,phone,email,sex,content) values ('" & request.form("name") & "'," & request.form("phone") & ",'" & request.form("email") & "','" & request.form("sex") & "','" & request.form("content") & "')" )
%>
怎么还不可以啊？？
你要是这样提交的话真有点会出错的！！！！
set rs = server.CreateObject ("adodb.recordset")
sql="select * from 表 "
rs.open sql,conn,3,3
if rs.eof then
rs.addnew
'要提交的数据
'例子 rs("name")=request.form("name")
rs.update
rs.close
set rs=nothing
这样看很难看出，你试试这样：
str="insert into dbq (name,phone,email,sex,content) values ('" & request.form("name") & "'," & request.form("phone") & ",'" & request.form("email") & "','" & request.form("sex") & "','" & request.form("content") & "')"
response.write(str)
看看输出的是否你想要的语句
name是关键字,要加[]
<%
set rst=conn.Execute("insert into dbq ([name],phone,email,sex,content) values ('" & request.form("name") & "'," & request.form("phone&quo