出错啦,高手帮帮忙
<!-- #include file="Show.asp" -->
<%
'=============连接数据库===============
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.ConnectionString="driver={SQL Server};server=LENOVO-
PC;UID=sa;PWD=;Database=Discuss"
Conn.Open
'============从表Content中读取用户数据==============
Set rs=Server.CreateObject("ADODB.Recordset")
Set rs.ActiveConnection = Conn
rs.CursorType = 3
flag=request.querystring("flag")
cid=request.querystring("id")
if flag=1 then
'打开记录集
rs.Open "SELECT * FROM Content WHERE UpperId=0 ORDER BY IsTop ASC, LastAnswerTime
DESC"
else
rs.Open "SELECT * FROM Content WHERE UpperId=0 and CateId=" & cid & "ORDER BY IsTop
ASC, LastAnswerTime DESC "
end if
'设置每页记录数
rs.PageSize = 5
'读取参数Page,表示当前的页码
Page = CLng(Request("Page"))
'处理不合法的页码
If Page < 1 Then Page = 1
If Page > rs.PageCount Then Page = rs.PageCount
%>
<html>
<head>
<!--
.main { font-size: 9pt }
-->
</style>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>全部帖子</title>
<style>
<!--
.main { font-size: 10pt }
-->
</style>
</head>
<body topmargin="0" background="images/Back.jpg" vlink="#000000" link="#000000">
<a name="top"></a>
<div align="center">
<center>
<h2>全部帖子</h2>
<table width="714" border="0" height="218" cellspacing="0" cellpadding="0">
<tr> <td height="18" class="main"> <% Call ShowPage( rs, Page ) %></td></tr>
<tr> <td height="21" class="main"> <% Call ShowList( rs, Page ) %> </td></tr>
<tr><td height="15" class="main" ><p align=right><a href="#top">返回顶部
</a> <a href="index.asp">返回首页</a></td></tr>
<tr> <td height="15"> </td></tr>
</table>
</body>
</html>
Microsoft OLE DB Provider for ODBC Drivers '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]在关键字 'ORDER' 附近有语法错误。
\artlist.asp, line 18
请大家帮个忙,我才刚学