<%text1=Request("text1") %>
<%text2=Request("text2") %>
<%text3=Request("text3") %>
<%
set conn=server.createobject("adodb.connection")
conn.open="driver={sql server};server=127.0.0.1;uid=sa;pwd=;database=tjphone"
set rs=conn.execute("tianjin")
%>
<%
if text1<>""or text2<>"" or text3<>"" then
sql="select * from tianjin where chanpin like " & "'%" &text1& "%'" & " and xingzhi like " & "'%" &text2& "%'" &"and lxdd like " & "'%" &text3& "%'"
set rs=conn.execute(sql)
while not rs.eof
row="<tr align=middle>"
for i=0 to rs.fields.count-1
row=row&"<td>"&rs(i)&"</td>"
next
Response.Write row&"</tr>"
rs.movenext
wend
rs.close
else
Response.Write("没有找到相关数据")
end if
%>
这是一个查询浏览,我希望可以分页,可以帮我加个分页功能吗,谢谢了.
