[求助]为什么定义的指针总是发生冲突？？
</head><body>
<%
Set conn=Server.CreateObject("ADODB.Connection")
DBPath1=server.MapPath("zp.mdb")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& DBPath1
conn.open connstr
set rs=server.createobject("adodb.recordset")
sql="select * from admin where admin='"&request("admin")&"' and password='"&request("password")&"'"
rs.open sql,conn,3,3
if session("pass")<>"" then
if rs.eof or bof then
response.Write("<SCRIPT languae=JavaScript>alert('系统中没有您的资料，请您重新注册!');</script>")
response.Write("<SCRIPT languae=JavaScript>history.go(-1);</script>")
else
session("admin")=rs("admin")
session("pass")=rs("pass")
end if
end if
%>
<%
hid = Request("hid")
if hid = "1" then
sqlPersonSelect = "select * from person where 1=1 "
if Request("name") <> "" then
sqlPersonSelect = sqlPersonSelect & " and name like '%"& Request("name") &"%' "
end if
if Request("direction") <> "0" then
sqlPersonSelect = sqlPersonSelect & " and ypfx like '%"& Request("direction") &"%' "
end if
else
if rs("pass")="2" then
sqlPersonSelect = "select * from person where ypfx='4' and (B_Check=0 or B_Check=1 or B_Check=2) order by B_Check desc"
elseif rs("pass")="3" then
sqlPersonSelect = "select * from person where B_Check<>0 order by B_Check desc "
else
sqlPersonSelect = "select * from person"
end if
end if
%>
<p> </p>
<P align="center"><span class="style3">注册人员列表</span>
<form action="DisplayList.asp?hid=1" name="form1" method="post">
<%if rs("pass")="2" then %>
<select name="direction" class="style3" id="select2">
<option value="4">财务</option>
</select>
<%else%>
<FONT face="宋体">
姓名：
<INPUT id="Name" type="text" name="name">
应聘方向：
<select name="direction" class="style3" id="select2">
<option value="0" selected>-----请选择-----</option>
<option value="1" >采编</option>
<option value="2">激光照排与技术</option>
<option value="3">网站</option>
<option value="4">财务</option>
<option value="5">广告发行经营</option>
<option value="6">行政后勤</option>
</select>
<%end if%>
<input type="submit" name="Submit1" value="查询" ID="Submit1">
</FONT>
</form>
</P>
<%set conn = Server.CreateObject("ADODB.Connection")
conn.Open dsn
set rsPerson = server.createobject("ADODB.Recordset")
rsPerson.Open sqlPersonSelect, conn, 1, 1%>
<TABLE width="88%" border="1" align="center" cellPadding="5" cellSpacing="0" bordercolor="#999999" bgcolor="#FFFFFF" id="Table1">
<TR>
后面还有呢，太多了。它总提示是，那些红字的地方，说是“发生冲突”能告诉我是什么意思吗？我现在急用。谢谢了
