Ad:

ASP Discussion Thread
Marked Solved
Views: 698

Jun 22nd, 2010

populating dropdown with SQL and making selection a session variable

Expand Post »

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.

[CODE]
<%
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
%>

Similar Threads

Storing last_insert_id() in a session variable in PHP
Aspx in Notepad - populate a dropdown with SQL DB & query in ASP.NET
session variable error in PHP
Session Variable clashing in ASP.NET
Losing session variable problem...help! in ASP

bevssi

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

8 posts
since Dec 2009

Permalink

Jun 24th, 2010

Re: populating dropdown with SQL and making selection a session variable

You may have to change the order of things for what you want...

ASP Syntax (Toggle Plain Text)
<%
strMonth = Request("month")
Session("ccrmonth")= strMonth
 
strSQL = "SELECT * from oMonth Order By oMonth.omonth_id"
Set rs = conn.Execute(strSQL)
	If not rs.eof then
		strMonth = rs("month")
	end if
	rs.Close
Set rs = Nothing
%>
 
 
<form method="post" action=""
	<select name="month" size="1">
                <option value="">Select</option>
                <option value="01" <% if strMonth="01" then response.write" SELECTED" end if %>>January</option>
                <option value="02" <% if strMonth="02" then response.write" SELECTED" end if %>>February</option>
                <option value="03" <% if strMonth="03" then response.write" SELECTED" end if %>>March</option>
                <option value="04" <% if strMonth="04" then response.write" SELECTED" end if %>>April</option>
                <option value="05" <% if strMonth="05" then response.write" SELECTED" end if %>>May</option>
                <option value="06" <% if strMonth="06" then response.write" SELECTED" end if %>>June</option>
                <option value="07" <% if strMonth="07" then response.write" SELECTED" end if %>>July</option>
                <option value="08" <% if strMonth="08" then response.write" SELECTED" end if %>>August</option>
                <option value="09" <% if strMonth="09" then response.write" SELECTED" end if %>>September</option>
                <option value="10" <% if strMonth="10" then response.write" SELECTED" end if %>>October</option>
                <option value="11" <% if strMonth="11" then response.write" SELECTED" end if %>>November</option>
                <option value="12" <% if strMonth="12" then response.write" SELECTED" end if %>>December</option>
	</select>
</form>
<%
strMonth = Request("month")
Session("ccrmonth")= strMonth

strSQL = "SELECT * from oMonth Order By oMonth.omonth_id"
Set rs = conn.Execute(strSQL)
	If not rs.eof then
		strMonth = rs("month")
	end if
	rs.Close
Set rs = Nothing
%>


<form method="post" action=""
	<select name="month" size="1">
                <option value="">Select</option>
                <option value="01" <% if strMonth="01" then response.write" SELECTED" end if %>>January</option>
                <option value="02" <% if strMonth="02" then response.write" SELECTED" end if %>>February</option>
                <option value="03" <% if strMonth="03" then response.write" SELECTED" end if %>>March</option>
                <option value="04" <% if strMonth="04" then response.write" SELECTED" end if %>>April</option>
                <option value="05" <% if strMonth="05" then response.write" SELECTED" end if %>>May</option>
                <option value="06" <% if strMonth="06" then response.write" SELECTED" end if %>>June</option>
                <option value="07" <% if strMonth="07" then response.write" SELECTED" end if %>>July</option>
                <option value="08" <% if strMonth="08" then response.write" SELECTED" end if %>>August</option>
                <option value="09" <% if strMonth="09" then response.write" SELECTED" end if %>>September</option>
                <option value="10" <% if strMonth="10" then response.write" SELECTED" end if %>>October</option>
                <option value="11" <% if strMonth="11" then response.write" SELECTED" end if %>>November</option>
                <option value="12" <% if strMonth="12" then response.write" SELECTED" end if %>>December</option>
	</select>
</form>

ArtistScope

Reputation Points: 5

Solved Threads: 14

Junior Poster

Offline

146 posts
since Jun 2010

Permalink

Oct 26th, 2010

Re: populating dropdown with SQL and making selection a session variable

Thanks to all who replied. It took me forever, but I finally got it right!

ASP Syntax (Toggle Plain Text)
 
<form method="post"  name="monthdrop">
<select name="rmonth" onchange="document.monthdrop.submit();" size="1" >
<option>Please select a month</option><%
 
 
Set rs1 = Conn.Execute("SELECT DISTINCT omonth_id, month FROM omonth order by omonth.omonth_id")
 
do while Not rs1.eof
 
rmonth=rs1("month")
 
 
If Request.Form("rmonth") <>"" Then
Session("ccrmonth")=request.form("rmonth")
 
bmonth=True
End If
%>
 
<option value="<%=rmonthid%>"><%=rmonth%></option>
 
<%
rs1.movenext
Loop
 
rs1.Close
Set rs1=Nothing
 
%>
</select>
</form>
<%
If bmonth then
 
 
Response.Write(""& Session("ccrmonth") &"")
Response.Write(""& rmonth &"")
 
End If
%>
<form method="post"  name="monthdrop">
<select name="rmonth" onchange="document.monthdrop.submit();" size="1" >
<option>Please select a month</option><%


Set rs1 = Conn.Execute("SELECT DISTINCT omonth_id, month FROM omonth order by omonth.omonth_id")

do while Not rs1.eof

rmonth=rs1("month")


If Request.Form("rmonth") <>"" Then
Session("ccrmonth")=request.form("rmonth")

bmonth=True
End If
%>

<option value="<%=rmonthid%>"><%=rmonth%></option>

<%
rs1.movenext
Loop

rs1.Close
Set rs1=Nothing

%>
</select>
</form>
<%
If bmonth then


Response.Write(""& Session("ccrmonth") &"")
Response.Write(""& rmonth &"")

End If
%>

bevssi

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

8 posts
since Dec 2009

Permalink

Oct 26th, 2010

Re: populating dropdown with SQL and making selection a session variable

Thanks to all who replied. It took me forever, but I finally got it right!

[CODE]

<form method="post" name="monthdrop">
<select name="rmonth" onchange="document.monthdrop.submit();" size="1" >
<option>Please select a month</option><%

Set rs1 = Conn.Execute("SELECT DISTINCT omonth_id, month FROM omonth order by omonth.omonth_id")

do while Not rs1.eof

rmonth=rs1("month")

If Request.Form("rmonth") <>"" Then
Session("ccrmonth")=request.form("rmonth")

bmonth=True
End If
%>

<option value="<%=rmonthid%>"><%=rmonth%></option>

<%
rs1.movenext
Loop

rs1.Close
Set rs1=Nothing

%>
</select>
</form>
<%
If bmonth then

Response.Write(""& Session("ccrmonth") &"")
Response.Write(""& rmonth &"")

End If
%>

bevssi

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

8 posts
since Dec 2009

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP Forum Timeline: Accessing Virtual Directory file

Next Thread in ASP Forum Timeline: ASP Coding For Online System with SQL Server

DaniWeb Message

Cancel Changes

User Name
Password