According to jquery ui API, the source of an autocomplete field may be an array variable. How can I populate the array variable with results from a vbscript recordset result?
In the body of my page the I have my code something like this:
Dim rs, data_source
Set rs = Server.CreateObject("ADODB.Recordset")
rs.ActiveConnection = MM_rtasql_STRING
rs.CursorType = 2
rs.CursorLocation = 2
rs.LockType = 3
rs.source = "select field1 from mydatabase where whatever > soandso"
WHILE NOT rs.EOF
//add each result to string array JavaScript/Jquery can access.
I would like to pull the variable in my document ready function for my jquery auto complete field. How can this be implemented?
Thank You.