和田龙农庄游玩攻略:这个查询语句该怎么设啊,求助.????

来源:百度文库 编辑:高考问答 时间:2024/04/29 19:25:13
<%
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"