ASP如何实现模糊查询并分页列表显示0
zkzh=replace(trim(Request("zkzh")),"'","")
studentname=replace(trim(Request("studentname")),"'","")
score=replace(trim(Request("score")),"'","")
CheckCode=replace(trim(Request("CheckCode")),"'","")
if CheckCode="" then
response.write("")
end if
if session("CheckCode")="" then
response.write("")
end if
if CheckCode<>CStr(session("CheckCode")) then
response.write("")
end if
%>
商标名称详细在册商标信息商标注册号为详细在册商标信息在册商标详细信息
dim sql
sql="select * from studentinfo where zkzh='"&zkzh&"'"
sql="select * from studentinfo where studentname='"&studentname&"'"
sql="select * from studentinfo where score='"&score&"'"
set rs=conn.execute(sql)
if rs.eof or rs.bof then
response.write"
暂时没有你所查询在册商标的详细信息!"
else
%>
商标名称: | "" then%> " target=blank> height=150 width=200> 此信息无图片 | |
商标注册号: | ||
商标类别: | ||
注册人名称: | ||
注册人地址: | ||
商标范围; | ||
管辖单位: | ||
所属辖区; | ||
注册时间: |
end if
rs.close
set rs=nothing
%>