缺少对象: 'select * from info w'

来源：百度知道 编辑：UC知道 时间：2024/07/04 15:14:13
<!--#include file="conn.asp"-->
<%
dim maxperpage,curpage,i,rank,keyy,invert,typeid,Keycount,sql
keyy=request("key")
maxperpage=20 '显示新闻条数
typeid=trim(request("type"))
if typeid="client" then '按文章标题查找
set rs=server.createobject("adodb.recordset")
rs="select * from info where client like '%" & keyy & "%' order by time DESC"
rank="客户名称"
end if
if typeid="serve" then '按文章标题查找
set rs=server.createobject("adodb.recordset")
rs="select * from info where serve like '%" & keyy & "%' order by time DESC"
rank="服务项目"
end if
response.Write("  您按照 <font color=ff0000>"&rank&"</font> 方式，以关键词 <font color=ff0000>"&keyy&"</font> 查询,总共找到 <font color=ff0

sql="select * from info where client like '%" & keyy & "%' order by time DESC"
rs.open sql,conn,1,3
rank="客户名称"
end if
if typeid="serve" then '按文章标题查找
set rs=server.createobject("adodb.recordset")
sql="select * from info where serve like '%" & keyy & "%' order by time DESC"
rs.open sql,conn,1,3
rank="服务项目"

晕
RS错了。应该是：
set rs=server.createobject("adodb.recordset")
rs.open "select * from info where serve like '%" & keyy & "%' order by id DESC" ,conn

或
set rs=conn.execute("select * from info where serve like '%" & keyy & "%' order by id DESC")