如何在JavaScript多维数组中存储ASP记录集? [英] How to store a asp recordset in javascript multi-dimensional array?

问题描述

我正在尝试将记录集存储在javascript的多维数组中，这是我当前的代码:

I''m trying to store a recordset in a multi-dimensional array in javascript, this is my current code:

var cn = new ActiveXObject("ADODB.Connection");
var strConn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source = c:\\BoMQuizWebAppv1.1\\BookOfMormonQuiz.mdb;"

cn.Open(strConn);

var rs = new ActiveXObject("ADODB.Recordset");
var sql = "SELECT * FROM Questions;"

rs.Open(sql,cn);

var count = new ActiveXObject("ADODB.Recordset");
sql = "SELECT COUNT(*) FROM Questions;"

count.Open(sql,cn);

var total = count(0);

questions = new Array(total);
	
for (i = 0; i < total - 1; i++) {
	questions[i] = new Array(10);	
}

for (i = 0; i < total - 1; i++) {
   for (j = 0; j < 10; j++) {
      questions[i][j] = rs(j);
   }
}

我已经在这件事上待了好几个小时了，我快要疯了！！！
有人可以帮我吗?

I''ve been in this thing for hours, I''m driving crazy!!!
Can someone help me, Please?

推荐答案

请尝试下面的代码.我已使用名为cstate的表作为示例，请将其替换为您自己的表名.

Please try the code below. I have used a table named cstate as a sample kindly replace it with your own table name.

<%
dim con, opt
set con = server.createobject("adodb.connection")
con.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = c:\\BoMQuizWebAppv1.1\\BookOfMormonQuiz.mdb;"
set rs = Server.CreateObject("ADODB.Recordset")
rs.CursorLocation = 3
rs.open "select * from cstate", con
%>
<script language="javascript">
rowCount = "<%=rs.recordcount%>"
colCount = "<%=rs.fields.count%>"
var states = new Array(<%=rs.recordcount%>)
alert(states.length);
for(i = 0; i < states.length; i++)

{

    states[i] = new Array(<%=rs.fields.count%>)
}
<%
    i = 0

    while (not rs.eof)
        j = 0
        for each k in rs.fields
        %>
        states[<%=i%>][<%=j%>] = "<%=k.value%>"
        <%
            j = j + 1
        next
        i = i + 1
        rs.movenext
    wend
%>
for(i = 0; i < states.length; i++)

{

    for(j = 0; j < states[i].length; j++)

    {

        document.write(states[i][j]);

    }

}



</script>

这篇关于如何在JavaScript多维数组中存储ASP记录集?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！