28,409
社区成员




<%
r1=request.form("r1")
if tp="danwei" then %>
<tr>
<td height="636" align="center" valign="top"> <table width="100%" border="0" cellpadding="0" cellspacing="6" class="font_12_23"> <%
set rs1=server.CreateObject("adobd.recordset")
rs1.open "select * from chaxun where danwei ",conn,1,1
if rs1.eof or rs1.bof then
%> <tr>
<td colspan="2">暂无信息.. </td>
</tr>
<%
else
for i=1 to rs1.recordcount
%>
<tr>
<td width="15%" height="34" align="center">单位: </td>
<td width="85%" align="left"> <%=rs1("danwei")%> </td>
</tr>
<tr>
<td height="29" align="center">电话: </td>
<td height="29" align="left"> <%=rs1("tel")%> </td>
</tr>
<%
rs1.movenext
next //这行的next
rs1.close
end if
%>
</table> </td> </tr>
<%
elseif r1="tel" then
%>
<tr>
<td height="636" align="center" valign="top">
<table width="100%" border="0" cellpadding="0" cellspacing="6" class="font_12_23">
<%
rs1.open "select * from chaxun where danwei ",conn,1,1
if rs1.eof or rs1.bof then
%> <tr>
<td colspan="2">暂无信息.. </td>
</tr>
<%
else
for i=1 to rs1.recordcount
%>
<tr>
<td width="15%" height="34" align="center">单位: </td>
<td width="85%" align="left"> <%=rs1("danwei")%> </td>
</tr>
<tr>
<td height="29" align="center">电话: </td>
<td height="29" align="left"> <%=rs1("tel")%> </td>
</tr> <%
rs1.movenext
next //这行的next 和上边的一样
rs1.close
end if
%> </table> </td>
</tr>
<%
rs.close
end if%>