How to pass a code from a list box to a processing asp form

[jck1]

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 that the user chooses from the list box 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.

 

[ChrisHirst]

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.

is that a typo in your post? otherwise there is your problem.


Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.

 

[jck1]

Sorry, it was indeed a typo. Any other thoughts about where the above code is wrong. Thanks.

 

[ChrisHirst]

are you POSTing or GETing the form

are you seeing any values if you response.write out the form collection?





Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.

 

[DreXor]

<% 
Do while not RS_Year.EOF
    Response.Write "<Option Value='" & RS_Year("CODE")& "'>" & RS_Year("YEAR") & "</OPTION>" & vbcrlf
    RS_Year.MoveNext
Loop
%>

DreX
aKa - Robert
if all else fails, light it on fire and do the happy dance!
" I always think outside the 'box', because I'm never inside the 'loop' " - DreX 2005

 

[DreXor]

replace rs_year("code") with rs_year("yearID")... i didn't see the field name listings in your sample data above.

DreX
aKa - Robert
if all else fails, light it on fire and do the happy dance!
" I always think outside the 'box', because I'm never inside the 'loop' " - DreX 2005