小弟有重要问题请教，请各位大哥帮忙

[zxy0527]

<%
database="rack.mdb"
strconnect="driver={microsoft access driver(*.mdb)};_
DBQ="&server.mappath(database)"
set objconn=server.createobject("adodb.connection")
objconn.open strconnect
set rs=server.createobject("adodb.recordset")
rs.open"select * from rack",objconn,adopenforwardonly
do while not rs .eof
response.write rs("r_exp"&"r_plucode"&"r_price")
response.write ("<br>")
re.movenext
loop
re.close
objconn.close
%>

该段代码各位大哥帮我看看错在哪了,郁闷啊

[wangwm]

<%
database="rack.mdb"
strconnect="driver={microsoft access driver(*.mdb)};DBQ="&server.mappath(database)
set objconn=server.createobject("adodb.connection")
objconn.open strconnect
set rs=server.createobject("adodb.recordset")
rs.open "select * from rack",objconn,1,3
do while not rs.eof
response.write rs("r_exp")&rs("r_plucode")&rs("r_price")
response.write ("<br>")
rs.movenext
loop
rs.close
objconn.close
%>

[learsu]

set rs=server.createobject("adodb.recordset")
rs.open"select * from rack",objconn,adopenforwardonly
do while not rs .eof
response.write rs("r_exp"&"r_plucode"&"r_price")
换成
set rs = objconn.execute("select * from rack")
response.write rs("r_exp")&rs("r_plucode")&rs("r_price")