刚学到一个办法,把你的月份和日期存成日期型,下面是一个SQL查询的例子: SELECT * FROM exhibit WHERE (MONTH(stardate) = 3) AND (YEAR(stardate) = 2006) AND (DAY(stardate) = 7) 这样你查到的日期是2006年3月6日的,剩下的还用我说吗?
本来无一物,何处惹尘埃
It is empty at all here, Why pm 2.5 is so TMD high!
<% numyue=month(date()) numri=day(date()) sql="SELECT * FROM sq1 WHERE (MONTH(stardate) ="&numyue&") AND (YEAR(stardate) ="&numri&") " Set rs= Server.CreateObject("ADODB.Recordset") rs.open sql,conn,1,1 do while not rs.eof %><%response.Write rs("llsq")%> <%rs.movenext loop rs.close%> 我改成了这样,还是慢死