<%Call ConnectionDatabase
sql="select top 8 * from yx_art where cid=58 order by id desc"
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,1,1
do while not rs.eof and not rs.bof
%>
[Quote=引用 1 楼 lzp4881 的回复:]
<%Call ConnectionDatabase '调用ConnectionDatabase
sql="select top 8 * from yx_art where cid=58 order by id desc"'查询cid=58的最新8条记录
set rs=server.CreateObject("adodb.recordset")'定义记录集
rs.open sql,conn……
[/Quote]
<%Call ConnectionDatabase '调用ConnectionDatabase
sql="select top 8 * from yx_art where cid=58 order by id desc"'查询cid=58的最新8条记录
set rs=server.CreateObject("adodb.recordset")'定义记录集
rs.open sql,conn,1,1'打开记录集
do while not rs.eof and not rs.bof'循环记录集
%>