asp 不提示错误 但就是加不进数据库

来源:百度知道 编辑:UC知道 时间:2024/06/27 06:40:44
<%
xm=request.form("xm")
shengfengzheng=request.form("shengfengzheng")
xb=request.form("xb")
nl=request.form("nl")
jg=request.form("jg")
youjian=request.form("youjian")
dianhua=request.form("dianhua")
ruzhuriqi=request.form("x_65E5671F")
rzfangjianhao=request.form("rzfangjianhao")
qita=request.form("qita")
xmlx=request.form("xmlx")
yajin=request.form("yajin")
set conn=server.createobject("adodb.connection")
conn.connectionstring="provider=microsoft.jet.oledb.4.0;"&"data source="&server.mappath("data/zhuyao.mdb")
conn.open
set rs=server.CreateObject("adodb.recordset")
sql="select * from yonghu where xm='"&xm&"'"
rs.open sql,conn,3,3
if rs.eof then
sqlsa="insert into y

呵呵,你只是设定了变量,并没有用具体的语句去操作它。肯定没有写进数据库了!
sqlsa="insert into yonghu(xm,xmlx,shengfengzheng,xb,nl,jg,youjian,dianhua,ruzhuriqi,rzfangjianhao,qita,yajin) values('"&xm&"','"&xmlx&"','"&shengfengzheng&"','"&xb&"','"&nl&"','"&jg&"','"&youjian&"','"&dianhua&"','"&ruzhuriqi&"','"&rzfangjianhao&"','"&qita&"','"&yajin&"')"
这个语句只是把写入数据的命令赋值给变量sqlsa,而这个命令并没有执行啊!
还有问题您可以Q我:39155985

重装试试..可能设置出错!