FROM 子句语法错误 高手帮帮忙哦！

<%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 s

请教高手：FROM 子句语法错误。 FROM 子句语法错误 高手帮帮忙哦！ asp FROM 子句语法错误。 FROM 子句语法错误 from 子句语法错误 ！ 急~~~FROM 子句语法错误 Adodc控件 from子句语法错误 ASP数据库：FROM 子句语法错误 ASP 的 过程出现 FROM 子句语法错误 ASP,FROM 子句语法错误,实在找不到原因