Menu
Hi,
I’ ve this problem: I’ m not able to put the value of pippo variable inside SQL select. How can I do ??
Thanks a lot in advance !!!
<body>
<form>
<select name=”list_month” id=”list_month”>
<option value=”ALL” selected>ALL</option>
<option value=”January”>January</option>
<option value=”February”>February</option>
</select>
<script>
var pippo = document.getElementById(‘list_month’).value;
document.write(pippo);
</script>
</form>
…..
<%
Set objConn = Server.CreateObject(“ADODB.Connection”)
objConn.ConnectionString = “DSN=sal.dsn”
objConn.Open
strSQL = “SELECT * FROM ” & table & ” WHERE Month LIKE ‘%” & pippo & “%'”
Set objRS = objConn.Execute(strSQL)
….