Help with if then statment

I want to write an if then statement so that a record only displays if there is something in the entry other than "Select Month" and "Select Day" (the first selection in two drop down menus). I don't know the proper way to write this in code. Can someone take a look at what I've got and help me out? I'm using ASP VBScript. Thanks.

 <% If rsevents.monthto <> "Select Month" And rsevents.dayto <> "Select Day" Then %>
                    to <%=(rsevents.Fields.Item("monthto").Value)%>&nbsp;<%=(rsevents.Fields.Item("dayto").Value)%>
  <% End If ' end rsevents.EOF And rsevents.BOF %>

recordset = rsevents
column names = monthto and dayto
LVL 4
elliottbenzleAsked:
Who is Participating?
 
RouchieConnect With a Mentor Commented:
Try this as an alternative to your first line:

<%
If rsevents.Fields.Item("monthto").Value<> "Select Month" AND rsevents.Fields.Item("monthto").Value <> "Select Day" THEN
%>

Let me know the outcome...
0
 
elliottbenzleAuthor Commented:
wroks great. thanks
0
All Courses

From novice to tech pro — start learning today.