<%
sSql = "Select columnname From tablename"
Set rst = Server.CreateObject("ADODB.RecordSet")
rst.Open sSql, conn, 3, 3
%>
<script language="JavaScript">
var arrColumn = new Array(<%= rst.RecordCount %>);
<%
i = 0
Do While Not rst.Eof
%>
arrColumn[<%= i %>] = "<%= rst("columnname") %>";
<%
i = i + 1
rst.MoveNext
Loop
%>
</script>
sSql = "Select columnname From tablename"
Set rst = Server.CreateObject("ADODB.RecordSet")
rst.Open sSql, conn, 3, 3
%>
<script language="JavaScript">
var arrColumn = new Array(<%= rst.RecordCount %>);
<%
i = 0
Do While Not rst.Eof
%>
arrColumn[<%= i %>] = "<%= rst("columnname") %>";
<%
i = i + 1
rst.MoveNext
Loop
%>
</script>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货