asp调用access数据库,能指定哪一条记录吗?能从第2条开始读?
<%setrs_product=server.createobject("adodb.recordset")sqltext4="selecttop1*fromproduc...
<%
set rs_product=server.createobject("adodb.recordset")
sqltext4="select top 1 * from product order by id asc"
rs_product.open sqltext4,conn,1,1
%>
<%i=0
do while not rs_product.eof%>
<a href="" target="_self" >1<%=rs_product("title")%>1</a><p><%=cutstr(rs_product("Content"),92)%></p><a>
<img src="<%=rs_product("DefaultPicUrl")%>" border="0" class="pngfix" width="60" height="60" /></a>
<%rs_product.movenext
i=i+1
if i=3 then exit do
loop
rs_product.close %> 展开
set rs_product=server.createobject("adodb.recordset")
sqltext4="select top 1 * from product order by id asc"
rs_product.open sqltext4,conn,1,1
%>
<%i=0
do while not rs_product.eof%>
<a href="" target="_self" >1<%=rs_product("title")%>1</a><p><%=cutstr(rs_product("Content"),92)%></p><a>
<img src="<%=rs_product("DefaultPicUrl")%>" border="0" class="pngfix" width="60" height="60" /></a>
<%rs_product.movenext
i=i+1
if i=3 then exit do
loop
rs_product.close %> 展开
1个回答
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询