请高手答一下?这是站内搜索的一段代码?

来源:百度知道 编辑:UC知道 时间:2024/04/29 03:28:46
<% set rs=server.createobject("ADODB.Recordset")
rs.open "SELECT*FORM list where title and word like '%'&request.form("word")&"%'",mynn,adOpenStatie
%>

错误类型:
Microsoft VBScript 编译器错误 (0x800A0401)
语句未结束
/web/search.asp, line 16, column 78
rs.open "SELECT*FORM list where title and word like '%'&request.form("word")&"%'",MyCon,adOpenStatie
-----------------------------------------------------------------------------^

请高手答一下?这是站内搜索的一段代码?

web/search.asp, line 16, column 78
rs.open "SELECT*FORM list where title and word like '%'&request.form("word")&"%'",MyCon,adOpenStatie 把这里的adOpenStatie 改为1,1试试看

少了一个双引号,在like '%'后面
rs.open "SELECT*FORM list where title and word like '%'"&request.form("word")&"%'",MyCon,adOpenStatie

另外你的SQL语句应该有问题,title也是列名吧?他后面应该也有条件阿