注册 登录
编程论坛 ASP技术论坛

新手请教读取数据问题

flashcsx 发布于 2011-07-11 19:52, 372 次点击
下面代码读取不到,请高手帮助,谢谢:

<% response.charset="utf-8" %>
<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="&Server.MapPath("sxl/userMsg.mdb")
set rs=server.createobject("adodb.recordset")
rs.open "select * from Msg order by id desc",conn,1,1
do while not rs.eof
while not rs.eof
response.Write "#"
response.Write rs("userName")
response.Write "|"
response.Write rs("userMsg")
response.Write "|"
response.Write rs("userTime")
rs.movenext
loop
rs.close
set rs = nothing
set conn = nothing
%>
3 回复
#2
dzt00012011-07-12 08:30
代码没有问题。请检查表名、字段名是否都正确,错误提示是什么?
#3
szchenli2011-07-12 12:43
会不会是数据库的位置你没有放对。这样 把这段conn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="&Server.MapPath("sxl/userMsg.mdb")换成conn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="&Server.MapPath("/sxl/userMsg.mdb") 试试。
#4
donfag2011-07-12 16:52
去掉"while not rs.eof"语句
1