<%
set rs=server.CreateObject("adodb.recordset")
sql="select id from TABLE_A"
rs.open sql,conn,1,1
%>
<script language="javascript">
var xxx=new Array();
<%
do while not rs.eof
%>
xxx[xxx.length]="<%= rs("id") %>";
<%
rs.movenext
loop
%>
</script>
set rs=server.CreateObject("adodb.recordset")
sql="select id from TABLE_A"
rs.open sql,conn,1,1
%>
<script language="javascript">
var xxx=new Array();
<%
do while not rs.eof
%>
xxx[xxx.length]="<%= rs("id") %>";
<%
rs.movenext
loop
%>
</script>
var sConnStr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=your.mdb";
oConn.Open(sConnStr); var oRs = new ActiveXObject("ADODB.Recordset");
oRs.Open("select * from yourTable",oConn,1,1);
data = new Array();
var i=0;
while(!oRs.EOF){
var row = new Array();
for(var j=0;j<oRs.Fields.Count;j++){
row[j]=oRs(j).Value;
}
data[i]=row;//把字段值读到数组里.
i++;
oRs.MoveNext();
}
oRs.Close();
oRs = null;