raced up:怎么读第二条记录sql="select top 1 * from NEWS whe
来源:百度文库 编辑:杭州交通信息网 时间:2024/05/13 17:00:35
<%
sql="select top 1 * from NEWS where firstImageName<>'' and ok=true order by ID DESC"
set rs=conn.execute(sql)
if not Rs.eof then
%>
sql="select top 1 * from NEWS where firstImageName<>'' and ok=true order by ID DESC"
set rs=conn.execute(sql)
if not Rs.eof then
%>
<%
sql="select top 5 * from NEWS where firstImageName<>'' and ok=true order by ID DESC"
set rs=conn.execute(sql)
if not Rs.eof then
%>
为读前5条纪录,修改数字就好了
可以去
www.oukan.net
看看
用sql语句直接获取第二条很麻烦,但是在具体环境中用记录集方法可以简单获取第二条。
if not rs.eof then
rs.movenext
if not rs.eof then
xxx=rs.fields(0).value
else msgbox()
endif
endif
sql="select top 1 * from (select top 2 * from NEWS where firstImageName<>'' and ok=true order by ID) order by id desc"