%
p_name = trim(request("p_name"))
if p_name <> "" then
sql = "select * from product where p_name like '%"&p_name&"%' order by p_id desc"
else
sql = "select * from product where p_name <> '' order by p_id desc"
end if
set rs = server.createobject("adodb.recordset")
'response.write sql
rs.open sql,conn,1,1
if conn.Errors.Count <> 0 then
response.write "数据库连接故障,请联系管理员...1"
end if
if not isempty(request("page")) then
pagecount=cint(request("page"))
else
pagecount=1
end if
'response.write sql
'response.end
rs.pagesize=12
rs.AbsolutePage=pagecount
%>