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 "
------解决方案--------------------
多了引号,改改就行了
------解决方案--------------------
顶