Share this page 

Pass data from a resultset to Javascript ArrayTag(s): Varia


On the server-side, the ASP code executes a query, the result is written in FORM hidden field (each value is separated by a ","). Then from Javascript (on the client-side), each hidden field value is extracted to an array,

Of course, JSP code can be used instead of ASP!

<%
'---
'ASP (server-side)
'---
Set Connection = Server.CreateObject("ADODB.Connection")
Connection.Open strConn

Set rs = Connection.Execute("SELECT field1, field2 from mytable")
Do While NOT rs.EOF
   field1 = field1 & rs("field1") & ","
   field2 = field2 & rs("field2") & ","
   rs.MoveNext
loop
field1 = Left(field1,len(field1)-1)
field2 = Left(field2,len(field2)-1)
%>

<!--HTML (client-side)-->
<form name="dataholder" action="#">
   <input type="hidden" name="field1" value="<%=field1%>">
   <input type="hidden" name="field2" value="<%=field2%>">
</form>

<script language="JavaScript">
   var something = "";
   //Fetch the data from the server-side
   var field1 = document.dataholder.field1.value;  
   //returns an array
   var arrField1 = field1.split(",");              
   var field2 = document.dataholder.field2.value;   
   var arrField2 = strField2.split(",");        
   for(var i=0; i < field1.length;i++) {
      something += arrField1[i]; 
      something += arrField2[i];
   }
</script>