asp编写的网页，读取数据库时，找不新建的表中数据，rs.eof 为真（此网页可读取别的表中的数据）

<%
size=request("size")
c1=request("case")
if size="" then
size=20
end if

n=1
title=trim(request("title"))
action=request("action")
sh=request("sh")
set rs=server.createobject("adodb.recordset")
if action="branch" then
if title="" then
sql="select * from xc_jhzj where username='"&session("username")&"' order by actdata desc" '正常模式
else
sql="select * from xc_jhzj where username='"&session("username")&"' and branch='"&title&"' order by actdata desc" '正常模式
end if
elseif action="actdata" then
if title="" then
sql="select * from xc_jhzj where username='"&session("username")&"' order by actdata desc" '正常模式
else
sql="select * from xc_jhzj where username='"&session("username")&"' and year(actdata)='"&title&"' order by actdata desc" '正常模式
end if
else
sql="select * from xc_jhzj where username='"&session("username")&"' order by actdata desc"

end if
rs.open sql,conn,1,1
rs.pagesize=size

'实现分页开始。
if rs.Eof then
rs_total = 0
else
rs_total = rs.RecordCount
end if
dim pageno
maxpage=rs.pagecount
getpageno = (Request("pageno"))
if(getpageno = "")then
pageno = 1
else
pageno = getpageno
End if
if(not rs.Eof)then
rs.AbsolutePage = pageno
end if

if rs.eof and rs.bof then
%>

<%
response.end
end if
k=1
repeat_rows = 0
While(repeat_rows < rs.PageSize and Not rs.Eof)
%>

<%= k %>
"><%=rs("Branch")%>
" href="jsbas_show.asp?id=<%=rs("id")%>"><%=left(rs("actname"),24)%>
"><%=year(rs("actdata"))%>
<%=rs("actdata")%>
<%=year(rs("addtime"))%>-<%=month(rs("addtime"))%>-<%=day(rs("addtime"))%>
<% if rs("actfj")<>"" then %>
" target="_blank">
<% end if %>
">编辑 '};">删除

<%
repeat_rows = repeat_rows + 1
k=k+1
rs.MoveNext
Wend
'rs.movenext
'loop
%>

你把临时用response.write(sql)输出，复制到查询分析器中执行，是否有数据？