UC知道SQL添加记录
来源：百度知道 编辑：UC知道 时间：2024/06/21 03:00:26
if Request.Form("id")<>"" and Request.Form("password")<>"" and Request.Form("email")<>"" and Request.Form("job")<>"" and Request.Form("data")<>"" and Request.Form("nickname")<>"" and Request.Form("sex")<>"" Then
Dim strSql
StrSql="insert into main(Id,Password,Email,Job,Data,Nickname,Sex) values('" & Request.form("id") & "','" & Request.Form("password") & "','" & Request.Form("email") & "','" & Request.Form("job") & "','" &
Request.Form("data") & "','" & Request.Form("nickname") & "','" & Request.Form("sex") & "')"
db.execute(strSql)
Response.Redirect"main.asp"
Dim strSql
StrSql="insert into main(Id,Password,Email,Job,Data,Nickname,Sex) values('" & Request.form("id") & "','" & Request.Form("password") & "','" & Request.Form("email") & "','" & Request.Form("job") & "','" &
Request.Form("data") & "','" & Request.Form("nickname") & "','" & Request.Form("sex") & "')"
db.execute(strSql)
Response.Redirect"main.asp"
首先你这些这行的单语句都必须在一行上
如果是这样的话
那么就把所有的单引号和双引号都重新敲一遍，很可能是单双引号敲反了
你把StrSql分成几行写看行不。
就是类似
StrSql="insert into main "
StrSql=StrSql&"(id,[password],"
....
可能是因为折行引起错误，解析器误认为你写的的StrSql只有最前面的一行。
if （Request.Form("id")<>"" and Request.Form("password")<>"" and Request.Form("email")<>"" and Request.Form("job")<>"" and Request.Form("data")<>"" and Request.Form("nickname")<>"" and Request.Form("sex")<>"" ）
if语句加上括号试试
说了啊.
Password要改成[Password]
关键字..