帮我看看是什么问题?加了order by就出错
这是不加order by的代码,运行正常
<%
sql = "select * from news where trim(lm) < 14 "
Set rs = Server.CreateObject("ADODB.RecordSet")
rs.Open sql,conn,1,1
if rs.recordcount<>0 then
rs.movefirst
for i=1 to 12
%>
<tr>
<td height="20"><a href="article.asp?id=<%=rs("id")%>" target=_blank><%=left(rs("title"),18)%>…</a></td>
<td align="left"><%=rs("time")%></td>
</tr>
<%
rs.movenext
if rs.eof then exit for
next
end if
rs.close
set rs=nothing
%>
加了order by time(time为日期时间型)之后就出错了
sql = "select * from news where trim(lm) < 14 order by time desc"
加了order by就出错,高手告诉我是什么问题啊?急