网游之风中凌乱书包网:这个查询语句该怎么设啊,求助.????

来源:百度文库 编辑:高校问答 时间:2024/05/16 09:03:11
<%
Dim a
a=Request.QueryString("Newsl_sort")

Dim rs,strSql
strSql="Select * From News where News_sort= ????? Order By News_sort"
Set rs=conn.Execute(strSql)
Do While Not rs.Eof
%>

strSql="Select * From News where News_sort='" & a & "' Order By News_sort"