Webmaster Forum / ColdFusion / Getting Started / March 2006

I have the following code for items that get placed on an Upcoming Events page:

<cfquery name="eventList" datasource="Functions">
SELECT TOP 3 EventDate,Title, OneLineDesc, Description, EventTime,
EventTimeTo, SubCategory, Name
FROM Events5051, EventsSubCategories5051
WHERE Events5051.SubCategoryID=EventsSubCategories5051.SubCategoryID
                AND EventDate>= #CreateODBCDate(now())#
ORDER BY EventDate, EventTime ASC
</cfquery>
<cfoutput query="eventList">
<cfquery name="getStartTime" datasource="Functions">
SELECT *
FROM DateTimeFormat
WHERE TimeValue='#eventList.EventTime#'
</cfquery>
<cfquery name="getEndTime" datasource="Functions">
SELECT *
FROM DateTimeFormat
WHERE TimeValue='#eventList.EventTimeTo#'
</cfquery>
<cfset varTimeStart = #getStartTime.TimeDisplay#>
<cfset varTimeStop = #getEndTime.TimeDisplay#>
#varTimeStart# - #varTimeStop#<br >
      #eventList.Description#</p>
    <p class="style2">#eventList.OneLineDesc#</p>
    <p class="style2">'#eventList.Title#'</p>
    <p class="style2">Organized by #eventList.Name#</p>    </td>
       </cfoutput>

This gives me the following output for the Top 3 items in the database:

Event Type
Event Date
Event Time
EVent Location
Event Speaker&Affiliation
Event Title
Event Organizer

What I would like this to do is to have the top item disappear after the time
has expired rather than the date. Many people like to see the next upcoming
event that same day rather than have to wait until the date expires. I am not
sure how to accomplish this and where the change should be placed in the code.

Thanks for the help.