ASP 问题 请高手帮我看看,这段代码有什么错误
请高手帮我看看,这段代码有什么错误。。谢谢!!!
<%
sql="select top "&index3&" id,enid,jtzw,addtime from job order by job.addtime desc "
rs.open sql,conn,1,1
if rs.recordcount=0 then
rs.close
response.write "暂时没有推荐职业!"
else
%>
<table border="0" width="563" cellspacing="0" cellpadding="0" id="table12" height="49">
<tr>
<td height="25" bgcolor="#FEEBD5" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="198" align="center">
<p align="left"> <b> 招聘职位</b></td>
<td height="25" colspan="2" align="center" bgcolor="#FEEBD5" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; ">
<p align="left"><b> 公 司</b> </td>
<td height="25" bgcolor="#FEEBD5" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="111" align="center">
<div align="left"><b>日 期</b></div></td>
</tr>
<%
for ii=1 to index3
sql="select id as uid,vip,name from en_user where id='"&rs("enid")&"' "
rs1.open sql,conn,1,1
%>
<tr>
<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="198" height="25" align="center" background="images/bg1.gif"><div align="left"><a target =_blank href="company.asp?id=<%=rs1("uid")%>">
</a> <a target =_blank href="job.asp?id=<%=rs1("id")%>"><%=rs1("jtzw")%></a></div></td>
<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="248" height="25" align="center" background="images/bg1.gif"><div align="left"><a target =_blank href="job.asp?id=<%=rs("id")%>">
</a><a target =_blank href="company.asp?id=<%=rs1("uid")%>">
<%=rs1("name")%></a>
<%if rs1("vip")=true then response.write "<font color='#FF0000'>(VIP)</font>"%>
</div></td>
<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="6" height="25" align="center" background="images/bg1.gif">
<p align="left"> </td>
<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="111" height="25" align="center" background="images/bg1.gif">
<div align="left">
<%
a=instr(rs("addtime"),chr(32))-1
response.write Mid(rs("addtime"),1,a)
%>
</div></td>
</tr>
<%
rs1.close
rs.movenext
if rs.eof then exit for
next