调式出问题,帮我看看~~~'FORM' 附近有语法错误 马上给分
------------------------------------------
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]第 1 行: 'FORM' 附近有语法错误。
/shopping/search.asp, 第 12 行
浏览器类型:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
网页:
GET /shopping/search.asp
--------------------------------------------------------------
代码是:
<%
set conn = Server.CreateObject("ADODB.Connection")
strConnectString = "Driver={SQL Server};Server=new;Database=bobo;Uid=sa;Pwd=123;"
conn.Open strConnectString
%>
<% set rs=server.createobject("ADODB.Recordset")
rs.open "SELECT*FORM list where title and word like '%"&request.form("word")&"%'",Conn,adOpenStatie
%>
--------------------------------------------------------------------------------------
是不是少'号???使用like 是'%变量%'.字符型变量.是不是要写成'"&&"'?
感觉应该写成:
rs.open "SELECT*FORM list where title and word like '%'"&request.form("word")&"'%'",Conn,adOpenStatie
可是还是出现一样错误