用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
