找错误

wxcyz wxcyz 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
<%
'从提交表单返回值,并查看是否有非法自符
uid=replace(request("uid"),"'","’")
pwd=replace(request("pwd"),"'","’")
email=replace(request("email"),"'","’")
sex=request("sex")
age=replace(request("age"),"'","’")
namez=replace(request("namez"),"'","’")
govz=replace(request("govz"),"'","’")
shengz=replace(request("shengz"),"'","’")
cityz=replace(request("cityz"),"'","’")
dizhiz=replace(request("dizhiz"),"'","’")
tel=replace(request("tel"),"'","’")
postnumber=replace(request("postnumber"),"'","’")
fax=replace(request("fax"),"'","’")

if fax="" then fax="未填写"



'开始向数据库写入数据,并检测是否已有此用户
set rs = Server.CreateObject("ADODB.Recordset")
sql = "SELECT * FROM zuser where uid= '" & uid & "'"
rs.open sql,conn,1,3

if not (rs.Bof or rs.eof) then
rs.Close
set rs=nothing
response.redirect "error.asp?err=004"
response.end
else

sql="insert into zuser(uid,pwd,email,sex,age,namez,govz,shengz,cityz,dizhiz,tel,postnumber,fax) values ('"&uid&"','"&pwd&"','"&email&"','"&sex&"','"&age&"','"&namez&"','"&govz&"','"&shengz&"','"&cityz&"','"&dizhiz&"','"&tel&"','"&postnumber&"''"&fax&"')"
conn.Execute(sql) '这句出错

response.redirect "index.asp"
end if

%>
...全文

相关推荐

评论 2
收藏 已收藏
分享
返回顶部
wxcyz
ASP 28,401 成员 356,940 内容