Question

sql查询记录建立ASP数组

Answer 1

<script type="text/javascript">
var arr1=new array();

<%
sql = "select answer from question where tixingid = 3"
set rs = server.CreateObject("adodb.recordset")
rs.open sql,connbbs,1,1
Dim a() '定义a数组
Dim l
l = 0
While Not Rs.EOF
%>

arr1 =<%= Rs("answer")%> //保存新数据
<%

Rs.MoveNext
Wend
rs.close
set rs = nothing
%>
</script>