If Statement Not Working as Expected in ASP Classic

Question

I have an if..else statement that will display whether or not the student is qualified to go for competition based from the value in database. But, my code is not working correctly.

My code is as follows:

<% If (rs_view.Fields.Item("StudentStatus").Value="OK") Then %>
<strong><font color="#3300FF" size="-1" face="Arial, Helvetica, sans-serif">
<%Response.Write("You are QUALIFIED to go for competition")%>
</font></strong>

<% Else %>

<strong><font color="#FF0000" size="-1" face="Arial, Helvetica, sans-serif">
<%Response.Write("You are NOT QUALIFIED to go for competition")%>
</font></strong>

<% End If %>

Any ideas?

• it doesn't work correctly..meaning either the student is qualified or not qualified, it will still display NOT QUALIFIED for both status.

Answer 1

Perhaps the StudentStatus field in your recordset is lowercase? Wrap it in a UCase()?

Also, you can really simplify that code for readability...

<%
Dim RspMsg, RspColor
If (UCase(rs_view("StudentStatus"))="OK") Then 
    RspMsg = "You are QUALIFIED to go for competition"
    RspColor = "#3300FF"
Else
    RspMsg = "You are NOT QUALIFIED to go for competition"
    RspColor = "#FF0000"
End If

%>

<strong><font color="<%=RspColor%>" size="-1" face="Arial, Helvetica, sans-serif">
<%=QualificationResponse%></font></strong>

Answer 2

You have loads of redudant code.. this code does the same as yours, but a bit reduced. You should also move the styling into a stylesheet.

<%
If rs_view("StudentStatus") & "" = "OK" Then
  %><strong><font color="#30f" size="-1" face="Arial, Helvetica, sans-serif">You are QUALIFIED to go for competition</font></strong><%
Else
  %><strong><font color="#f00" size="-1" face="Arial, Helvetica, sans-serif">You are NOT QUALIFIED to go for competition</font></strong><%
End If
%>

Now, StudentStatus is simply not OK. What you need to do is ouput StudentStatus and see what it is, e.g. insert the following before or after the code in your question (or the reduced variant above) and check it's output:

<%
Response.Write "*" & Server.HTMLEncode(rs_view("StudentStatus")) & "*"
%>

Possible causes is that the OK is in small caps, it's padded by spaces or isn't OK at all, but instead 1 or true or whatever.