我有一张表名pinmu 需要查询的字段为GOODSITEMNAME
这是一段代码请问出了什么问题 文件名a.asp
<!--#include file="inc/conn.asp"-->
<%
dim name
name=request("name")
set rs="select *from pinmu where name like'%name%'"
rs.open sql,conn,1,1
%>
<%
if not rs.eof and not rs.bof then
%>
<%=rs("name")%>
<% end if %>
Untitled-2.asp
<!--#include file="inc/conn.asp"-->
<%
dim name
name=request("name")
Response.Write "接受的参数值:"&Name
set rs="select * from pinmu where GOODSITEMNAME like '%"&name&"%'"
rs.open sql,conn,1,1
Set Rs=Conn.Execute("Select Top 10 * from pinmu Where Goodsitemname Like '%"&Name&"%'")
if not rs.eof then
Do While Not Rs.Eof
Response.Write rs("name")&"<br>"
Rs.MoveNext
Loop
Else
Response.Write "没有数据"
end if %>
<!--#include file="inc/conn.asp"-->
<%
dim name
name=request("name")
set rs="select * from pinmu where GOODSITEMNAME like '%"&name&"%'"
rs.open sql,conn,1,1
%>
<%
if not rs.eof then
%>
<%=rs("name")%>
<% end if %>
<!--#include file="inc/conn.asp"-->
<%
dim name
name=request("name")
set rs="select * from pinmu where GOODSITEMNAME like '%name%'"
rs.open sql,conn,1,1
%>
<%
if not rs.eof then
%>
<%=rs("name")%>
<% end if %>
set rs="select *from pinmu where name like'%name%'"
rs.open sql,conn,1,1
改成以下:
set rs=server.createobject("adodb.recordset")
'需要查询的字段为GOODSITEMNAME ,所以应该是 GOODSITEMNAME like
sql="select *from pinmu where GOODSITEMNAME like'%"&name&"%'"
rs.open sql,conn,1,1