数据库有三个表 DOWN DOWNFILE DOWNTYPE 我想读取DOWNPILE表的数据应该怎么写，自己写的不对，不知道哪里出错了 <% i=0 sql="select top 20 cxn,cxv,id,tid,hits,tp from downfile where date>Now()-365 order by hits desc" rs.open sql,conn,1,1 if rs.eof then %> <tr> <td width="100%" colspan="2" height="30" align="center">还没有数据</td> </tr> <% else do while not rs.eof %> <div><%rs("id")%><%rs("cxn")%></div> <% i=i+1 if i>18 then exit do rs.movenext loop end if rs.close %></DIV>
WHERE 语句有问题。 sql="select top 20 cxn,cxv,id,tid,hits,tp from downfile where date > #" & DataAdd("d", -365, Now()) & "# order by hits desc"