<%
Set rst= Server.CreateObject("ADODB.Recordset")
if whe="全部" then
sql="select articleid,title,hits from learning where canlook<>3 order by hits desc"
else
sql="select articleid,title,hits from learning where where='"&whe&"' and canlook<>3 order by hits desc"
end if
rst.open sql,conn,1,1
if rst.eof and rst.bof then
response.write "<p align='center'> 该栏目没有任何电影</p>"
else

i=0
do while not rst.eof
i=i+1
%>
这段代码是那错了SQL数据库怎么提示:
Microsoft OLE DB Provider for SQL Server 错误 '80040e14'
在关键字 'where' 附近有语法错误。

/where.asp，行 166

行 166 是 : rst.open sql,conn,1,1

<%
Set rst= Server.CreateObject("ADODB.Recordset")
if whe="全部" then
sql="select articleid,title,hits from learning where canlook<>3 order by hits desc"
else
sql="select articleid,title,hits from learning where where='"&whe&"' and canlook<>3 order by hits desc"
end if

rst.open sql,conn,1,1
if rst.eof and rst.bof then
response.write "<p align='center'> 该栏目没有任何电影</p>"
else

i=0
do while not rst.eof
i=i+1
%>

多了一个where