用Flash和ASP做留言本-ASP篇(上)

这个是关于view.ASP的源程序：

<%constr = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.Mappath("luiyan.mdb") & ";"

set conn = server.createobject("ADODB.Connection")

conn.open constr

Set rs = Server.CreateObject("ADODB.Recordset")

sql="select * from message order by id"

rs.open sql,conn,3,1

rs.movefirst // 连接数据库

response.write("&total="&rs.recordcount)

do while not rs.eof

response.write("&name"&rs("id")&"="&rs("name"))

response.write("&text"&rs("id")&"="&rs("text"))

rs.movenext

loop

rs.close