dim lj lj="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& Server.MapPath("list.mdb")set conn=server.createobject("adodb.connection")conn.openljset rs=server.createobject("ADODB.Recordset") rs.open "SELECT*FORM list WHERE title and word like '%" & request.form("word") & "%'",conn,1,1%> 统计查询共有条纪录
统计查询共有条纪录
原:rs.open "SELECT*FORM list WHERE title and word like &request.form("word")&'%'"rs,adOpenStatie新:Dim strSQLstrSQL="Select * From List Where [title] And [word] Like '"&Request.Form("word")&"%'"Rs.Open strSQL,lj,adOpenStatie
rs.open "SELECT*FORM list WHERE title and word like &request.form("word")&'%'"rs,adOpenStatie 改为rs.open "SELECT * FORM list WHERE title and word like "&request.form("word")&"%" lj,adOpenStatie 注意空格和变量、字符串的写法。