I'm rather new to this and really need some help. I know I'm close but I just can't get this to work. My omonth table has only 2 fields, id and month. I want a drop down to lists the months and I want the selected value to become a session variable. Can you please help? It should be very simple but I've spent hours trying to get it to work.
<%
Session ("ccrmonth")
strSQL=" select * from omonth order by omonth_id"
Set rs = conn.Execute(strSQL)
If not rs.eof then
%>
<form method="post" action="evanreports1.asp"
<select name="month" size="1">
<option value="<%=rs("month")%>"</option>
<%
rs.MoveNext
rs.Close
Set rs = Nothing
%>
</select>
</form>
<%
Session("ccrmonth")= request.form("month")
If rs(ccrmonth)<>"" Then
response.write "& ccrmonth &"
End If
%>