将查询的数据库元素赋值给一个数组并显示出来,请好心的高手指点!!!
首先将查询表_zb、字段z_zhjddw的数据赋值给变量数组maxid()
<%
dim maxid()
set conn = Server.CreateObject("ADODB.Connection")
conn.open = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("sjxt.mdb")
set rs=server.createobject("adodb.recordset")
sql1="select z_zhjddw from _zb order by id asc"
rs.open sql1,conn,1,1
For i=0 To rs.recordcount
maxid(i)=rs(i)
next
rs.Close
conn.close
%>
然后逐一显示出来
<p>
<%for i = 0 to To rs.recordcount%>
<%=maxid(i)%>
<%next%>
</p>
请问高手,我错在那里?应该怎么写?