qq关闭可能认识的人:请会asp的朋友帮我看看啊?

来源:百度文库 编辑:中科新闻网 时间:2024/04/29 19:34:37
<%
set dbrs=server.createobject("adodb.recordset")
dbsql="SELECT * FROM gongsi where qyname ='"&gsname&"'"
dbrs.open dbsql, conn, 1, 1
if dbrs.recordcount>=1 then
dbrs.close
response.redirect "qrgsze.asp"
else
session("qyname")=request("gsname")
session("qyxz")=request("gsxz")
session("zyhy")=request("zyhy")
session("clnx")=request("clnx")
session("zczj")=request("zczj")
session("tzze")=request("tzze")
session("xyyg")=request("xyyg")
session("lxren")=request("lxren")
session("qyfren")=request("qyfren")
session("telephone1")=request("telphone1")
session("telephone2")=request("telphone2")
session("chuanzhen")=request("chuanzhen")
session("mail")=request("mail")
session("wangzhi")=request("wangzhi")
session("province")=trim(province)
session("city")=trim(city)
session("county")=trim(county)
session("youbian")=request("youbian")
session("gzgangwei1")=request("gw1")
session("gzgangwei2")=request("gw2")
session("gzgangwei3")=request("gw3")
session("jyyaoqiu")=request("jyyaoqiu")
session("xlyaoqiu")=request("xlyaoqiu")
session("zyyaoqiu")=request("zyyaoqiu")
session("qtyaoqiu")=request("qtyaoqiu")
session("ygshuliang")=request("ygshuliang")
session("nvbl")=request("nvbl")
session("ygshiduan")=request("ygshiduan")
session("gzshijian")=request("gzshijian")
session("syshijian")=request("syshijian")
session("sygz")=request("zygz")
session("htgz")=request("htgz")
session("jbxs")=request("jbxs")
session("ssqk")=request("ssqk")
session("bxjnqk")=request("bxjnqk")
session("qtfldy")=request("qtfldy")
session("bz")=request("bz")
session("gstjren")=request("gstjren")
dbrs.close
set dbrs=server.createobject("adodb.recordset")
sql="select * from gongsi"
dbrs.open sql,conn,1,2
if not dbrs.eof then
dbrs.movelast
end if
dbrs.addnew
dbrs("qyname")=trim(request("gsname"))
dbrs("qyxz")=trim(request("gsxz"))
dbrs("jbxs")=trim(request("jbxs"))
dbrs("gstjren")=trim(request("gstjren"))
dbrs.update
if err>0 then
session("info4")="<li>服务器数据库操作失败!(最后存数据时)</li>"+ err.description
response.redirect "gz.asp"
else
session("info4")="<li>记录已保存!</li>"
response.redirect "gz.asp"
end if
response.write session("info4")
dbrs.close
end if

%>
这个是里面的部分代码~我想实现如果数据库中有就跳转,如果没有就添加~~不知道为什么就是实现不了,我添加的新数据也跳转~~请高手帮我啊

你发错地了
应该发到电脑数码那一块