50分 ASP 留言板
错误提示：Microsoft JET Database Engine (0x80040E14)
字符串的语法错误 在查询表达式 'subject like '%发达 % ' ' order by top1,lastdate desc ' 中。
/eml/default1.asp, 第 52 行
select case option1
case 1
SQL= "Select * From guest where subject like '% "&text& "% ' "& " ' "&jinghua& " order by top1,lastdate desc "
case 2
SQL= "Select * From guest where content like '% "&text& "% ' "& " ' "&jinghua& " order by top1,lastdate desc "
case 4
SQL= "Select * From guest where username= ' "&text& " ' "&jinghua& " order by top1,lastdate desc "
case else
sql= "SELECT * FROM guest where 1=1 "&jinghua& " ORDER BY top1,lastdate DESC "
end select
52行 rs.open sql,conn,3,3
[解决办法]
subject like '%发达 % ' '
~~多了引号
SQL= "Select * From guest where subject like '% "&text& "% '&jinghua& " order by top1,lastdate desc "
[解决办法]
多了引号,改改就行了
[解决办法]
顶
