<%sub down_body()
dim keyword,class_id,colname,totalsoft,Currentpage,totalpages,i
keyword=request("keyword")
cat_id=request("cat_id")
class_id=request("class_id")
colname=request("colname")

sql="SELECT * FROM soft order by soft_joindate desc"
if cat_id<>"" and class_id="" then
sql="SELECT * FROM soft soft_catid="&cat_id&" order by soft_joindate desc"
elseif class_id<>"" and keyword="" then
sql="SELECT * FROM soft soft_classid="&class_id&" order by soft_joindate desc"
elseif keyword<>"" and colname<>"0" then
sql="select * from soft "&colname&" like '%"&keyword&"%' order by soft_joindate desc"
elseif keyword<>"" and colname="0" then
sql="select * from soft soft_name like '%"&keyword&"%' or soft_desc like '%"&keyword&"%' order by soft_joindate desc"
else
sql="SELECT * FROM soft order by soft_joindate desc"
end if

set rssoft=server.createobject("adodb.recordset")
rssoft.open sql,conn,1,1
%>


错误类型：
Microsoft JET Database Engine (0x80040E14)
FROM 子句语法错误。
/aaaa/inc/down_body.asp, 第 22 行

怎么处理啊?紧急,在线等

有条件的话必须用where的
sql="select * from 表名 where 条件"

sql="SELECT * FROM soft order by soft_joindate desc"
if cat_id<>"" and class_id="" then
sql="SELECT * FROM soft where soft_catid="&cat_id&" order by soft_joindate desc"
elseif class_id<>"" and keyword="" then
sql="SELECT * FROM soft where soft_classid="&class_id&" order by soft_joindate desc"
elseif keyword<>"" and colname<>"0" then
sql="select * from soft where "&colname&" like '%"&keyword&"%' order by soft_joindate desc"
elseif keyword<>"" and colname="0" then
sql="select * from soft where soft_name like '%"&keyword&"%' or soft_desc like '%"&keyword&"%' order by soft_joindate desc"
else
sql="SELECT * FROM soft order by soft_joindate desc"
end if