Populating a Javascript array from SQL database values

Can anyone help with this issue.
I'm trying to populate a JavaScript array using values from an SQL database table.

My hardcoded array (which works) looks like this:

EmpNumber=new Array(111,222,333,444);

When I try to populate the array with values from an SQL database:

<%

Dim sql,Rs1

sql = ""
sql = sql & "SELECT EmpNumber FROM EmpFile "
Set Rs1 = Server.CreateObject("ADODB.Recordset")
Rs1.Open sql, DecryptedText(TheFile,"ConSQL"), 3
%>

EmpNumber=new Array(<%=Rs1("EmpNumber")%>);

I don't get an error message, but neither do I get any results. Any suggestions?