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.
declare connection ...
SQL = "Select * FROM
Field1 = ' "%>index<%" ' "
make connection with SQL statement...
I read around and it appears I cant directly do this. I have to use hidden fields? Can someone confirm this?