Im using the onchange event for a dropdown list to change SQL statements based on the index of that dropdown chosen. For example I have a function like this for my onchange event of the drop down list.
<script type=“text/javascript”>
function listboxchange(index)
declare connection …
<%
SQL = "Select * FROM mytable
WHERE Field1
= ’ “%>index<%” ’ "
make connection with SQL statement…
%>
Im trying to pass the javascript variable “index” into the SQL statement but its not working. Am I using the wrong syntax?