老师好!
news表中有字段articleid,title,picurl,classid,addtime.
实现的功能是:把栏目classid=3中的新闻图片从第5张开始,把栏目classid=20所有图片合在一起集中显示,下面的代码不能实现,看书说用UNION联合查询又不会写,请教各位老师如何写这段代码?
<%set rs=server.CreateObject("adodb.recordset")
sql= "select articleid,title,picurl from news where (classid=20 or classid=3) order by addtime desc"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "<center><br><font color=red size=2>对不起，暂无图片！</font></font>"
response.End

如果用select * from new where classid=20 or classid=3 order by addtime desc查询，则会将classid为3的所有记录查询出来，不知怎么实现“从第5张开始”.不知是我不会做还是你说得我不能理解

谢谢! 我上面的代码sql= "select articleid,title,picurl from news where (classid=20 or classid=3) order by addtime desc"是楼上老师所说的意思,会把栏目3和栏20中所有图片都查出来。

我现在求助的是:如何取出栏目3中从第5张开始的图片加上栏目20中所有的图片。主要的意思是去掉classid=3的前5张图片后组成一个记录集RS。
相当于sql= "select articleid,title,picurl from news where classid=20 order by addtime desc"
sql= "select 去掉前5张 articleid,title,picurl from news where classid=3 order by articleid desc"
两个合在一起。

我觉得你要从CLASSID=3的栏目中取得第5个记录，这一定得需要将其记录向后移动5位，而要将记录向后移动就必须利用recordset对象的movenext方法

所以依我现在所学的知识，觉得这是办不到的。只能通过两个步骤才能完成。

sql1="select * from news where classid=3"
rs1.open sql1,conn,1,1
rs1.movePrevious
for i =1 to 5
if rs1.eof then
exit for
response.End
end if
rs1.movenext
next
id=rs1("id")
sql2="select * from news where classid=20 union select * from news where classid=3 and id>="&id
rs2.open sql2,conn,1,1
for j=1 to rs2.recordcount
if rs2.eof then
exit for
end if
<table>
......<!--显示图片-->
</table>
rs2.movenext
next

所以依我现在所学的知识，觉得这是办不到的。只能通过两个步骤才能完成。

sql1="select * from news where classid=3"
rs1.open sql1,conn,1,1
rs1.movePrevious
for i =1 to 6
if rs1.eof then
exit for
response.End
end if
rs1.movenext
next
id=rs1("id")
sql2="select * from news where classid=20 union select * from news where classid=3 and id>="&id
rs2.open sql2,conn,1,1
for j=1 to rs2.recordcount
if rs2.eof then
exit for
end if
<table>
......<!--显示图片-->
</table>
rs2.movenext
next

或

sql1="select * from news where classid=3"
rs1.open sql1,conn,1,1
rs1.movePrevious
for i =1 to 6
if rs1.eof then
exit for
response.End
end if
rs1.movenext
next
id=rs1("id")
sql2="select * from news where classid=20 union select * from news where classid=3 and id>"&id
rs2.open sql2,conn,1,1
for j=1 to rs2.recordcount
if rs2.eof then
exit for
end if
<table>
......<!--显示图片-->
</table>
rs2.movenext
next

谢谢您的回复,下面代码运行时,没有错误提示,也没有图片显示,什么原因?
<table border=0 cellpadding=0 cellspacing=0>
<tr>
<%set rs1=server.CreateObject("adodb.recordset")
sql1="select * from news where classid=3 order by addtime desc"
rs1.open sql1,conn,1,1
rs1.movePrevious
for i =1 to 6
if rs1.eof then
exit for
response.End
end if
rs1.movenext
next
id=rs1("articleid")
set rs2=server.CreateObject("adodb.recordset")
sql2="select * from news where classid=20 union select * from news where classid=3 and articleid>"&id
rs2.open sql2,conn,1,1
for j=1 to rs2.recordcount
if rs2.eof then
exit for
end if
%>
<td > <a href="tpxw.asp?id=<%=rs2("articleid")%>" class="list5" target=_blank><img src="<%=trim(rs2("picurl"))%>" alt="<%=rs2("title")%>" width="100" height="80" border="1" align="top" ></a >
</td>
<% rs2.movenext
next

%>
</tr>
</table>

如果是代码错误，你可以用SQL查询来试试，看看有没有结果

试试它：sql2="select * from news where classid=20 union all select * from news where classid=3 and articleid>"&id

谢谢qhscqb的回复,我把 sql2="select * from news where classid=20 union select * from news where classid=3 and articleid>"&id
换成sql2="select articleid,title,picurl from news where classid=20 union select articleid,title,picurl from news where classid=3 and articleid>"&id后,可以运行了,但是与要求反了,它显示了20所有的图片和栏目3的前5张图片,而不是去掉前5张.
请您再看下怎回事?再次感谢!!!!