麻烦给位高人帮看看看看排名这哪错了，帮改一下。急用。。。先谢谢了
<td height="60"><p align="center">精 英 十 二 杰
<table border="1" width="400" cellspacing="0" bordercolor="#000000" bordercolorlight="#000000" bordercolordark="#000000" cellpadding="0" style="border-collapse: collapse">
<%
Set OBJConn = Server.CreateObject("ADODB.Connection")
OBJConn.Open "dhyx","sa","123456"
sersql="select top 12 * from (select b.zname01,b.zname03,sum(a.bb) as acc2 from sqzz_2 a,sqzz_agnt b where a.agntnum=b.agntnum and sj>'20061128' and sj<'20061227' group by b.zname01,b.zname03) as t1where t1.acc2>999 order by acc2 DESC"
Set rs=OBJConn.Execute (sersql)
%>
<tr>
<td align="center">
<p><font color="#FF0000">排名</font></td>
<td align="center">
<p><font color="#FF0000">管理处</font></td>
<td align="center">
<p><font color="#FF0000">规模保费</font></td>
<td align="center">
<p><font color="#FF0000">标准保费</font></td>
<tr>
<%do while not rs.eof%>
<tr>
<td align="center"><font color="#0000FF"><%if j=1 then response.write("1") else if j=2 then response.write("2") else response.write("3") else response.write("4") else response.write("5") else response.write("6") else response.write("7") else response.write("8") else response.write("9") else response.write("10") else response.write("11") else response.write("12") end if%</font></td>
<td align="center"><font color="#0000FF"><%=rs("zname01")%></font></td>
<td align="center"><font color="#0000FF"><%=rs("zname03")%></font></td>
<td align="center"><font color="#0000FF"><%=rs("acc2")%></font></td>
</tr>
<%
rs.Movenext
j=j+1
loop
%>
<%
OBJConn.Close
Set rs = Nothing
Set OBJConn = Nothing
%>
</table>
HTTP 错误 500.100 - 内部服务器错误 - ASP 错误
Internet 信息服务
--------------------------------------------------------------------------------
技术信息（用于支持人员）
错误类型：
Microsoft VBScript 编译器错误 (0x800A0412)
必须是行中的第一个语句
/dh2/index.asp, line 101, column 94
if j=1 then response.write("1") else if j=2 then response.write("2") else response.write("3") else response.write("4") else response.write("5") else response.write("6") else response.write("7") else response.write("8") else response.write("9") else response.write("10") else response.write("11") else response.write("12") end if%</font></td>
---------------------------------------------------------------------------------------------^
浏览器类型：
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
网页：
GET /xs/index.asp
时间：
2006年12月22日, 18:48:12
