# ASP: uh oh

**URL:** <https://forum.kirupa.com/t/asp-uh-oh/142260>\
**Category:** Uncategorized\
**Created:** [March 27, 2005, 3:32am UTC](https://forum.kirupa.com/t/asp-uh-oh/142260 "2005-03-27T03:32:05Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![imported\_dinkumrocks](https://avatars.discourse-cdn.com/v4/letter/i/58f4c7/32.png) [@imported\_dinkumrocks](https://forum.kirupa.com/u/imported_dinkumrocks)\
**Post date:** [March 27, 2005, 3:32am UTC](https://forum.kirupa.com/t/asp-uh-oh/142260/1 "2005-03-27T03:32:05Z")

</div>

OK. Im making an admin panel for my bands site. i have it so i can update news and whatnot, but im kind of stuck with the shows part.

I have it so you can add shows and delete them. but i cant figure out the whole thing where the shows dont show up if the date has already passed.

say we had a show on the 25th. and its the 26th today. the show on the 25th shouldnt show up.

now for some code.

this is what i have now, but its not working.

```auto
 <%
set RSshows = Server.CreateObject("ADODB.Recordset")
set showsSQL = "SELECT TOP 4 * FROM events ORDER BY full_date WHERE full_date<=" & Date & ""
RSshows.Open showsSQL, Conn
RSshows.MoveFirst()
%>.
 
... 
<%if RSshows.Recordcount < 0 then%>There are no events currently booked.<%else%>
 
....else action....
 
then all the tables to show the shows.

```

thanks for any help.

-Naaman