Question

帮我看看这段代码错在哪里!我的意思是从数据库存里取出时间为今天的数据然后显示,但是怎么调试都不成功!

表中字段:jysj为日期格式
<%
dim date5
date5=date
set rs1=server.createobject("adodb.recordset")
exec="select * from kf where cdate(jysj)="&cdate("date5")
rs1.open exec,conn,1,1
if rs.eof or rs.bof then
Response.Write "没有记录"
else
Response.Write ""&rs1("kfh")&""
end if
%>
按二楼和三楼的意思,还是无法输出!
<%
dim date5
date5=date
set rs1=server.createobject("adodb.recordset")
exec="select * from kf where jysj ="&date5
rs1.open exec,conn,1,1
if rs1.eof or rs1.bof then
Response.Write "没有记录"
else
Response.Write ""&rs1("kfh")&""
end if
%>

Answer 1

sql语句不正确!
exec="select * from kf where cdate(jysj)="&cdate("date5")
改成
exec="select * from kf where jysj = '"&date5&"'

Answer 2

改为if rs.eof and rs.bof then