How to get value of combobox during Combobox index change in server side

harinarayananvp · October 21st, 2011, 01:14 PM

Hi,

I have one asp code like this

HTML Code:

<tr>
	<td  style="WIDTH:430px"><b>Release type</td>
	<td><SELECT style="LEFT: 454px; WIDTH: 220px; TOP: 413px" name="txtrt" id="txtrt">
	<OPTION value="" selected></OPTION>
<OPTION value="Kernel">Kernel</OPTION>
	<OPTION value="Cluster">Cluster</OPTION>
	<OPTION value="Custom">Custom</OPTION>
	</SELECT></td>

	<tr><td><b>Release Version</td>
<td>
	<%    
	rtyp=Request.Form("txtrt")
	  Set con=server.CreateObject("adodb.connection")
			con.Open session("Psrconnect")
			Set rs=server.CreateObject("Adodb.Recordset")
	
			
			rs.Open "select release_name from release_statistics where release_type='"&rtyp&"'",con
			
			
	%>				
	<SELECT style="LEFT: 454px; WIDTH: 220px; TOP: 413px" name="txtconsol2" id="txtconsol2">
	<OPTION value="Select Release" >Select Release</OPTION>
	<% do while rs.eof<>true
					
	%>
	<OPTION value="<%=rs.fields(0)%>" ><%=rs.fields(0)%>  </OPTION>
	
	<%
	rs.movenext 
	loop
	%>

Here, I am not able to get the value of 'txtrt' to rtyp. request.Form is working in other parts of the page. Why this is happening. how can get the value of 'txtrt', so that I can retrieve values from database based on that. Please help. I am playing around the problem for the last 2days. Is there is any alternate way to do this. I can get the value of txtrt using vb script. But,how can i pass that value to server side so that i can retrieve values from database