多条件查询的语法错误
<%if c_id<>0 then '//判断查询分类,分类不为空。
select case action
case "1"
sql1=" select * from news where topic like '%"&searchkey&"%' and c_id="&c_id&""
case "2"
sql1=" select * from news where word like '%"&searchkey&"%' and c_id="&c_id&""
end select
else
select case action
case "1"
sql1=" topic like '%"&searchkey&"%'"
case "2"
sql1=" word like '%"&searchkey&"%'"
end select
end if
sql1= "select * from news where "&sql1&" order by id desc"
set rs=edxsky_2in1.exec(sql1,1)
if rs.eof And rs.bof then
Response.Write "<p align='center' > 对不起,没有查询到您需要的新闻!</p>"
else.....(省略)%>
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] WHERE 子句语法错误。