45平米公寓装修效果图:这段代码哪错了啊,为什么不写库?,执行完了,数据库什么也没有

来源:百度文库 编辑:中科新闻网 时间:2024/05/03 06:38:38
<%
dim user,pwd,pwd2,question,answer,email,ip,lcok,regdate,stardate,enddate,point,hits,lastlogindate,yhlx
yhlx=1
lastlogindate=now()
hits=0
point=0
enddate=now()
stardate=now()
regdate=now()
ip=request.ServerVariables("REMOTE_ADDR")
user = Trim(Request("User"))
pwd = Trim(Request("pwd"))
pwd2 = Trim(Request("pwd2"))
question = Trim(Request("question"))
answer = Trim(Request("answer"))
Email = Trim(Request("Email"))

<%
sql="insert into [user1] (user,pwd,question,answer,email,ip,lock,regdate,stardate,enddate,point,hits,lastlogindate,yhlx) values ('"&user&"' , '"&pwd&"', '"&question&"', '"&answer&"','"&email&"','"&ip&"','"&point&"','"®date&"','"&stardate&"','"&enddate&"','"&point&"','"&hits&"','"&lastlogindate&"','"&yhlx&"')"
conn.execute(sql)
rs.close
set rs=nothing
Response.Write "<script language=JavaScript>" & chr(13) & "alert('恭喜您!您已经成为我们的会员了!');" & "index.asp" & "</script>"
%>
是不是里面的一个数据名写错,所有的都不会被写入?
insert into [user1] (user,pwd,regdate,stardate,enddate,point,hits,lastlogindate,question,answer,email,yhlx,ip,lock) values (33,windows,2005-12-29 8:51:17,2005-12-29 8:51:17,2005-12-29 8:51:17,0,0,2005-12-29 8:51:17,sdoifu,sodifu,cclt@163.com,1,127.0.0.1,-1)
调试以后显示这些,我觉得没什么问题啊/

没有提示错误?

调试一下么,在 conn.execute(sql) 之前写一条语句输出SQL,然后把结果放到数据库中执行一下,看有什么问题:

sql = "..."
Response.Write sql
Response.End
conn.execute(sql)