高考问答做皮冻水的比例:怎么读第二条记录sql="select top 1 * from NEWS whe
来源：百度文库 编辑：高考问答 时间：2024/04/30 13:52:36
<%
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"