Is it posible to pass a record set created from an sql statment using the "strsubjectrec = rstsubject.GetRows" format in to a a javascript fuction via an "OnChange" form event in asp.
What i am trying to achieve is to change a fixed field value on a form to a matching value, when a user changes another field from a drop down list, both sets of values are obtained from asql database, and as the form contains a considerable number of fields I do not want to recreate the form very time a value is changed.

Thanks in advance

Dave WX

I am not 100% sure what you're trying to accomplish.

If your question is whether you can pass the values from the recordset back to a JavaScript function, the answer is: yes you can.

Consider this:

<%
  Dim MyASPVariable
  MyASPVariable = "Hello"
%>


<script language="JavaScript" type="text/javascript">
  var MyJavaScriptVariable = '<%=MyASPVariable%>'
</script>

This way, the value of the server variable MyASPVariable will end up as a client side JavaScript variable called MyJavaScriptVariable.

If you combine this with some smart GetRows usage, you can return ready to use JavaScript arrays you can use in your client side code.

Kind regards,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.