getting error in my code

[simi28]

Hi all
I have a textbox in which data is coming from database.
now i want the data to dispaly some other field according to condition is true.
i have done the same in my asp page .
i m not getting any kind of error but it showing nothimg.
please help me to solve the problem.
my code is below:

////
<%
set rs2=server.CreateObject("ADODB.recordset")
ssql2="select * from leave_master where mid='"&eid&"'"
rs2.open ssql2,con,1,3
%>

<tr>
<td class="normal">Leave applied for,with the application</td>
<%if (request.Form("txtleave")="AL") then%>
<td class="normal"><%=(request.Form("txtday")%></td>
<%end if%>

<%if (request.Form("txtleave")="CL") then%>
<td class="normal"><%=(request.Form("txtday")%></td>
<%end if%>
<%if (request.Form("txtleave")="LWOP") then%>
<td class="normal"><%=(request.Form("txtday")%></td>
<%end if%>
</tr>
////

[gtilles]

Your not doing anything with the recordset.
You are using the request object in your if statements.
You probably want to use rs2("txtLeave")
Where is the relationship?