帮我看看这个句子......
<% set rs=server.createobject("ADODB.Recordset")
rs.open "SELECT*FROM list where title and word like '%"&request.form("word")&"%'",Conn,adOpenStatie
%>
提示错误:
-------------------------------------------------------
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]在关键字 'and' 附近有语法错误。
/shopping/search.asp, 第 12 行
浏览器类型:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
网页:
GET /shopping/search.asp
----------------------------------------------------------------------
我把and word删掉就没问题.....不能这样使用and??