Question

asp数据库条件查询问题

查寻整个数据库在字段aa中aa的值等于1的全部按id倒序显示出来
这是我写的代码,不能显示
求详细代码

<%a=1
Set rec=Server.CreateObject("ADODB.Recordset")
dim SQL1
SQL1="SELECT * FROM gongqiou where aa='+a+' order by ID desc"
rec.Open SQL1,cnn1,1,1,1
%>
按你的改了可还是不能显示啊

Answer 1

<%
'根本不需要定义 直接 where aa=1 就可以了
Set rec=Server.CreateObject("ADODB.Recordset")
SQL1="SELECT * FROM gongqiou where aa=1 order by ID desc"
rec.Open SQL1,cnn1,1,1
%>

Answer 2

改两行
SQL1="SELECT * FROM gongqiou where aa="&a&" order by ID desc"
rec.Open SQL1,cnn1,1,1

Answer 3

<%a=1
Set rec=Server.CreateObject("ADODB.Recordset")
dim SQL1
SQL1="SELECT * FROM gongqiou where aa="&a&" order by ID desc"
rec.Open SQL1,cnn1,1,1
%>
楼上的都写了，呵呵