sql分页查询session常用语句.txt

较为详细的介绍了asp自定义的各种函数,方便asp的各种开发.

<%
sql=""
set rs=server.createobject("adodb.recordset")
if saferequest("search","0")="true" then
	if saferequest("Class_1","0")<>"" then
		sql="select * from Product where Class_1='"&request("Class_1")&"'"
	end if
	if saferequest("Class_2","0")<>"" then
		if sql="" then
			sql="select * from Product where Class_2='"&request("Class_2")&"'"
		else
			sql=sql&" and class_2='"&request("Class_2")&"'"
		end if
	end if
	if saferequest("Product_Name","0")<>"请输入产品名称" and request("Product_Name")<>"" then
		if sql="" then
			sql="select * from Product where Product_Name like '%"&request("Product_Name")&"%'"
		else
			sql=sql&" and Product_Name like '%"&request("Product_Name")&"%'"
		end if
	end if
	if sql="" then
		session("sqlc")="select * from Product order by Product_Id"
	else
		session("sqlc")=sql
	end if
end if
	if sql="" then
		session("sqlc")="select * from Product order by Product_Id"
	else
		session("sqlc")=sql
	end if
'response.write sql
'response.write session("sqlc")
'response.end
rs.open session("sqlc"),conn,1,1
%>