asp数据查询及数据筛选
“排序”
<%
set rs=server.createobject("adodb.recordset")
sql="select * from [session] order by id DESC"
rs.open sql,conn,1,1
%>
order by为数据排序,DESC降序,ASC升序
“筛选”
<%
set rs=server.createobject("adodb.recordset")
sql="select * from recruitment where id=” &request.querystring("id")
rs.open sql,conn,1,1
%>
<%
set rs=server.createobject("adodb.recordset")
sql="select * from [sector_news] where audit='审核通过' and class='" & request("class") & "'"
rs.open sql,conn,1,1
%>
where为条件
request为获取,request.querystring为获取数值
or为或者
and为并且