那位高手 帮我看看这段代码

来源：百度知道 编辑：UC知道 时间：2024/05/17 11:08:54
<%@ language=vbscript%>
<% dim lj
lj="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& Server.MapPath("list.mdb")
set rs=server.createobject("ADODB.Recordset")
rs.open "SELECT*FORM list WHERE title and word like &request.form("word")&'%'"rs,adOpenStatie%>

<html>
<head><title>查询结果</title></head>

<body >

<cpalign="center"><br>
统计查询共有<% Response.rite(Resurrected) %>条纪录</cp><br>
<div align="center"></div><center></center>
<table border="1" align="center" border color="000000" eradicator="#000000" borecole="#ff">
<tar align="center">
<td width="20%" align="center" bicolor="#ff">ID</td>
<td width=&quo

dim lj
lj="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& Server.MapPath("list.mdb")
set conn=server.createobject("adodb.connection")
conn.open lj
set rs=server.createobject("ADODB.Recordset")
rs.open "SELECT*FORM list WHERE title and word like '%" & request.form("word") & "%'",conn,1,1%>

统计查询共有<% Response.rite(Resurrected) %>条纪录</cp><br>
统计查询共有<% Response.write(Resurrected) %>条纪录</cp><br>

rs.open "SELECT * FORM list WHERE title and word like '"&request.form("word")&"%'",1,1

原：
rs.open "SELECT*FORM list WHERE title and word like &request.form("word")&'%'"rs,adOpenStatie

新：
Dim strSQL

strSQL="Select * From List Where [title] And [word] Like '"&Request.Form("word")&"%'"