提取数据出错，该如何处理呢？

[xuallen]

我从数据库中按照如下语句选择记录，
sqlTS1="select * from tblReports where Sections='TS' and ReportMonth='"& ReportMonth &"' and ReportWeek='Week1'"
Set rsts1=conn.execute (sqlTS1)
但是当记录中没有"Week1"时总出现错误页面，
如何当没有匹配字符时就显示空记录呀？

[xiwanghope]

查处记录集以后要先判断是否为空然后再显示数据..

if rsts1.eof then
response.write("none")
else
.... '输出数据
end if

[sxsgssgs]

set rs=server.createobject("adodb.recordset")
sqlTS1="select * from tblReports where Sections='TS' and ReportMonth='"& ReportMonth &"' and ReportWeek='Week1'"
rs.open sqlTS1,conn,1,1
if rs.eof then
response.write "无记录！"
else
response.redirect "index.asp"
end if

[bzscs]

if rsts1.bof and rsts1.eof then
response.write("none")
else
.... '输出数据
end if
我通常这样

[swich]

if rsts1.eof or rsts1.bof then
....
else
....
end if

[linzhifeng]

if rstsl.eof and rstsl.bof then
...
end if

[reaperwu]

if rstsl.RecordCount = 0 then
'Response.Write "没有记录"
else
'输出记录
end if

[aoenzh]

在数据提交前，先判断是不是空。

[monkeys]

sqlTS1="select * from tblReports where Sections='TS' and ReportMonth='"& ReportMonth &"' and ReportWeek='Week1'"

Set rsts1=conn.execute (sqlTS1)

if rsts1.eof or rsts1.bof then
Response.write("很抱歉，没有你所要查询的信息")
else
输出你的记录
end if

[xeimm]

if rsts1.bof and rsts1.eof then
response.write("none")
else
.... '输出数据
end if