Question

SELECT 子句中包含一个保留字、拼写错误或丢失的参数，或标点符号不正确

错误类型：
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] SELECT 子句中包含一个保留字、拼写错误或丢失的参数，或标点符号不正确。
/delete/classview.asp, 第 155 行
<table border="1" width="100%" height="156">
<tr>
<td width="100%" height="2"><%

if page=1 or page=0 then
SQL="select top "&PageSize&" * from message where Classname='"&Classname&"' and Deleted=0 "&SqlAdd&" order by MsgID DESC"
else
SQL="select top "&PageSize&" * from message where Classname='"&Classname&"' and Deleted=0 "&SqlAdd&" and "
SQL=SQL & " MsgID not in (Select top "&Cstr(PageSize*(page-1))&" MsgID from message where "
SQl=SQL & " Classname='"&Classname&"' and Deleted=0 "&SqlAdd&" order by MsgID DESC)"
SQL=SQL & " order by MsgID DESC"
end if

*********************rs.Open SQL,conn 第 155 行
while not rs.eof
%>
<tr>
<td width="95%" height="23" bordercolor="#808080">
<img border="0" src="../class/images/mood7.gif">标  题：<%=rs("Title")%></td>
</tr>
<tr>
<td width="95%" height="22" bordercolor="#808080">
<img src="../class/images/userlist.gif">留言人：<%=rs("User")%></td>
</tr>
<tr>
<td width="95%" height="22" bordercolor="#808080"><img border="0" src="../class/images/mood0.gif">内 
容:<%=rs("comment")%></td>
</tr>
</center>
<tr>
<td width="95%" height="20" bordercolor="#808080">
<p align="right">留言于：<%=rs("RegTime")%> <a href="del2.asp?id=<%=rs("id")%>">删除</a>
</td>
</tr>
<tr>
<td width="95%" height="20" bordercolor="#808080"><hr color="#FFFF00">
</td>
</tr><%
rs.MoveNext
wend
rs.close
%>
<tr>
<td width="95%" height="20" bordercolor="#808080"><%

PageSize=3
rs.open "Select count(*) as c from message where Classname='"&Classname&"' and Deleted=0 "&SqlAdd,conn,1,3
PageCount=CInt(rs("c")/PageSize+0.5)
rs.Close
Page = CLng(Request("Page"))
if Page="" or isnull(Page) then page=1
If Page < 1 Then Page = 1
If Page > PageCount Then Page = PageCount
%>

</td>
</tr>
</table>
这是我毕业设计的最后一个问题！！麻烦解决一下哦！！之后我会追加分数的哦！！！拜托了

Answer 1

在rs.Open SQL,conn 这句之前加上
response.write(sql)
response.end()
看看浏览器打印出来的SQL语句和预期的sql语句差在那里，就知道那个参数没有接收到值了。