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 %>