序数词加形容词最高级:sql1 ="select * from news where feilei="& request("feilei")

来源：百度文库编辑：高校问答时间：2024/04/28 10:23:27

sql1 ="select * from news where feilei="& request("feilei")
则查询不出来
若sql1 ="select * from news where feilei='具体参数值'"则能查询出来
第一式能查询能找到有几条记录，就是显示不出来。第二式能查询能找到有几条记录，并能显示不出来。

sql1 ="select * from news where feilei='& request("feilei")&'"
这样写

你这样写是对的，楼上几位的写法也是对的，我想是不是你的request("feilei")没有传过来的原因，多调试一下。

sql1 ="select * from news where feilei='"& request("feilei")&"'"

你这样写的语句只用应用于数字查找,不能用于字符查找

如果是字符的话就要像二楼的那样写

sql1 ="select * from news where feilei="& request("feilei") sql1 ="select * from news where feilei="& request("feilei") sql1 ="select * from news where feilei="& request("feilei") sql="select * from……" sql = "Select top 5 * from news" abc = "select * from 医生信息 where 编号="&Text1.Text&" " sql = "Select * From [userinfo] Where userid = '"&userid&"'" ； sql="select top 10 * from jjh_news where news_fenlei="&Request("news_fenlei") SqlDataAdapter temp_ada = new SqlDataAdapter("select TOP 17 * from "+Lei+"",temp_con); rs_s.open "select * from shjia where username='"&request.cookies("godbook")("shjianame")&"