Question

如何提取ACCESS数据库里的某段记录，显示在ASP网页上？

Answer 1

可以 直接 使用 指针定位功能
程序实现：
set db=server.createobject("adodb.recordset")
strsql="select * from [Ameav_ADs] order by id asc"
db.open strsql,conn,1,1
db.absoluteposition=6
if not db.eof and not db.bof then
for i=6 to 10
response.write db("字段名")
db.movenext
if db.eof then exit for
next
end if
db.close
set db=nothing

本答案由 7+1自助建站 www.7jiayi.com (388元全包自助建站) 提供
QQ 920626076

Answer 2

set db=conn.execute("select * from [Ameav_ADs] order by id asc")
i=1
do while not db.eof
if i>=6 and i<=10 then
response.write db("字段")
end if
db.movenext
loop

Answer 3

select top 5 * from [Ameav_ADs] where ID not in (select top 5 id from Ameav_ADs)