求一个sql
数据库access,结构如下(表名:article)
id content sdate
1 aaa 2007-3-1
2 bbb 2007-2-28
3 ccc 2007-3-1
4 ddd 2007-2-28
<select name= "rq " size= "1 " >
<%
set rs1=server.createobject( "adodb.recordset ")
rs1.Open "select * from article order by id desc ",conn,1,1
do while not rs1.eof
dtdate=rs1( "sdate ")
%>
<option value= " <%=dtdate%> "> <%=dtdate%> </option> option中怎样实现2007-2-28、2007-3-1各只有一条
<%
rs1.movenext
loop
%>
</select>
[解决办法]
多写下个查询
-------------------------------------
'下拉列表选择[ 时间 ]
dim rs4,sql4
set rs4=server.CreateObject( "adodb.recordset ")
sql4= "select Distinct sdate from [article] order by sdate desc "
rs4.open sql4,conn,1,1
