请问谁知道哪里错了？？？？

[zhaoliangpat]

<%

set rs1=server.createobject("adodb.recordset")
sql1="select * from zl where 'a'='a' order by -id"
rs1.open sql1.conn


bb=0
do while not rs1.eof and bb<1


%>
<img src="dot12.gif" width="9" height="9">
<a href="#"><%=rs1("字段")%></a></td>


<%
rs1.movenext
bb1=bb1+1
loop

[zhaoliangpat]

<!--#include file="conn.asp"-->

<%

set rs=server.createobject("adodb.recordset")
sql="select * from zl where 'a'='a' order by -id"
rs.open sql.conn




bb=0
do while not rs.eof and bb<1


%>
<img src="*.gif" width="9" height="9">
<a href="#"><%=rs("字段")%></a></td>


<%
rs.movenext
bb1=bb1+1
loop



%>

[gabriel1]

出错提示，帖出来

[cqfeng]

sql1="select * from zl where 'a'='a' order by -id" ？？？

sql1="select * from zl where 'a'='a' order by id desc" 按倒序排列

[chinesun]

<!--#include file="conn.asp"-->
<%
set rs=server.createobject("adodb.recordset")
sql="select * from zl where 'a'='a' order by -id" //****************
________________________
sql="select * from zl where a='a' order by id"//a是字段名，不能加''，ID不要加-
________________________
rs.open sql.conn//****************
_________________________
rs.Open Sql,conn,1,1//这里必须改成这样，不是加.而是,
________________________
bb=0
do while not rs.eof and bb<1//你要表达的是什么意思？要实现什么目的？
%>
<img src="*.gif" width="9" height="9"><a href="#"><%=rs("字段")%></a></td>
<%
rs.movenext
bb1=bb1+1//***************是bb还是bb1?
loop
%>