日期:2013-06-27  浏览次数:20855 次

                             用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