怎么让asp读取最新的几条记录?

来源:百度知道 编辑:UC知道 时间:2024/05/26 01:44:23
下面的是我的代码,怎么让它只读取最新录入的三条信息呢?由于我是菜鸟,请直接复制代码来回答,谢谢!

=====================代码开始=============================

<%
set conn=server.CreateObject( "adodb.connection" )
set rs=server.CreateObject( "adodb.recordset" )
db="gg.mdb"
conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &server.MapPath(db)
sql="select * from gg order by id desc"
set rs=conn.execute(sql)
xmlfile=server.mappath("001.txt")
Set fso = CreateObject("Scripting.FileSystemObject")
Set MyFile = fso.CreateTextFile(xmlfile,True,True)
MyFile.WriteLine("<?xml version='1.0' encoding='utf-8'?>")
MyFile.WriteLine("<musicPlayer username=' '>")
MyFile.WriteLine("<playerConfig bgPic='0009.swf' topPic='toppic.swf'/> <effect>")
MyFile.WriteLine("<item name='mc1' url=&

=====================代码开始=============================

<%
set conn=server.CreateObject( "adodb.connection" )
set rs=server.CreateObject( "adodb.recordset" )
db="gg.mdb"
conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &server.MapPath(db)
sql="select top 3 * from gg order by id desc"
set rs=conn.execute(sql)
xmlfile=server.mappath("001.txt")
Set fso = CreateObject("Scripting.FileSystemObject")
Set MyFile = fso.CreateTextFile(xmlfile,True,True)
MyFile.WriteLine("<?xml version='1.0' encoding='utf-8'?>")
MyFile.WriteLine("<musicPlayer username=' '>")
MyFile.WriteLine("<playerConfig bgPic='0009.swf' topPic='toppic.swf'/> <effect>")
MyFile.WriteLine("<item name='mc1' url='190.swf' x='0' y='0&