UC知道ASP插入代码哪里有错误啊？
来源：百度知道 编辑：UC知道 时间：2024/06/12 11:25:18
<%
set rs=server.CreateObject("adodb.recordset")
num2=request.Form("username")
num3=request.Form("userpassword")
num4=request.Form("sex")
num6=request.Form("useremail")
num8=request.Form("shouhuodizhi")
num9=request.Form("youbian")
num10=request.Form("usertel")
num11=request.Form("userzhenshiname")
sql="insert into Dv_user(useryhm,usermima,realname,xingbai,useremail,userdizhi,postcode,tell) values('" & num2 & "','" & num3 & "','" & num4 &"','" & num6 & "','" & num8 & "','" & num9 & "','" & num10 & "'," & num11 & ")"
'response.Write(sql)
conn.execute sql
%>
我的能在下页显示这些信息，但是就是不能插入我的数据库
set rs=server.CreateObject("adodb.recordset")
num2=request.Form("username")
num3=request.Form("userpassword")
num4=request.Form("sex")
num6=request.Form("useremail")
num8=request.Form("shouhuodizhi")
num9=request.Form("youbian")
num10=request.Form("usertel")
num11=request.Form("userzhenshiname")
sql="insert into Dv_user(useryhm,usermima,realname,xingbai,useremail,userdizhi,postcode,tell) values('" & num2 & "','" & num3 & "','" & num4 &"','" & num6 & "','" & num8 & "','" & num9 & "','" & num10 & "'," & num11 & ")"
'response.Write(sql)
conn.execute sql
%>
我的能在下页显示这些信息，但是就是不能插入我的数据库
set rs=server.CreateObject("adodb.recordset")
num2=request.Form("username")
num3=request.Form("userpassword")
num4=request.Form("sex")
num6=request.Form("useremail")
num8=request.Form("shouhuodizhi")
num9=request.Form("youbian")
num10=request.Form("usertel")
num11=request.Form("userzhenshiname")
rs.open"insert into Dv_user(useryhm,usermima,realname,xingbai,useremail,userdizhi,postcode,tell) values('" & num2 & "','" & num3 & "','" & num4 &"','" & num6 & "','" & num8 & "','" & num9 & "','" & num10 & "'," & num11 & ")",conn,1,3
conn.execute rs
大概看了下，如果是数字型的要"&afasfasf&"不是‘"&afasfasf&"’
就是有没有单引号
sql="insert into Dv_user(useryhm,usermima,realname,xingbai,useremail,u