我想把“replaydateandtime”为空的数据库数量统计出来,为什么统计出来是所有数据库条目,而没有按照我的if条件筛选?
set rs=server.CreateObject("ADODB.RecordSet")
rs.Source="select id,title,dateandtime,hidden,replaydateandtime from email where bossid=" & jzid & wherestr & " order by ID DESC"
rs.Open rs.Source,conn,1,1
dim w
w=0
for i123=0 to rs.RecordCount-1
if len(rs(4)&"")=0 then
response.write.rs(4)&""
w=w+1
end if
set rs=server.CreateObject("ADODB.RecordSet")
rs.Source="select id,title,dateandtime,hidden,replaydateandtime from email where bossid=" & jzid & wherestr & " order by ID DESC"
rs.Open rs.Source,conn,1,1
dim w
w=0
for i123=0 to rs.RecordCount-1
if len(rs(4)&"")=0 then
response.write.rs(4)&""
w=w+1
end if