J
Jack
Hi,
I have a asp form where one element is a list box which lists four years
starting from 2004. This list is drawn from a database table which has YearID
and Year as two fields as shown below:
YearID YEAR
1 2004
2 2005
3 2006
4 2007
PART OF ASP CODE IS:
<tr>
<td width="74%" align ="center" height="18"><font face="Times New Roman"
size="3" color = "red">YEAR</font></td>
<td>
<SELECT NAME="lstYear" SIZE="1">
<% Do while not RS_Year.EOF
Response.Write "<Option Value='" & RS_Year("YEAR")& "'>"
Response.Write RS_Year("YEAR") & "</OPTION>"
RS_Year.MoveNext
Loop
%>
<td>
<tr>
Now I want to capture the value of the YearCode instead of the Year field
and store the year code value in the processing form to process in a sql
statement.
i.e. I am planning to use the Request.Form("lstYear") to capture the value
of the year code. However, Request.Form("listYear") is showing no value.
I would appreciate any help or any article link for handling this problem.
Thank in advance.
I have a asp form where one element is a list box which lists four years
starting from 2004. This list is drawn from a database table which has YearID
and Year as two fields as shown below:
YearID YEAR
1 2004
2 2005
3 2006
4 2007
PART OF ASP CODE IS:
<tr>
<td width="74%" align ="center" height="18"><font face="Times New Roman"
size="3" color = "red">YEAR</font></td>
<td>
<SELECT NAME="lstYear" SIZE="1">
<% Do while not RS_Year.EOF
Response.Write "<Option Value='" & RS_Year("YEAR")& "'>"
Response.Write RS_Year("YEAR") & "</OPTION>"
RS_Year.MoveNext
Loop
%>
<td>
<tr>
Now I want to capture the value of the YearCode instead of the Year field
and store the year code value in the processing form to process in a sql
statement.
i.e. I am planning to use the Request.Form("lstYear") to capture the value
of the year code. However, Request.Form("listYear") is showing no value.
I would appreciate any help or any article link for handling this problem.
Thank in advance.