Help filtering records
Posted on 2003-11-25
I'm trying to modify a calendar application I found. I've got a master calendar that displays events taking place in all the rooms in the database. Now I'm trying to write individual calendar views for each room.
I've got it working so the current month's events show up in the proper room, but if I try to advance a month, I get a blank calendar. I'm not sure if the problem lies in my select statement or the way I've got the link set up to advance to the next month.
rsEventsDay.Source = "SELECT * FROM EVENTS, TYPES WHERE EVE_APPROVED=1 AND EVE_TYPE = " + Replace(rsEventsDay__MMColParam, "'", "''") + " AND EVE_TYPE = TYPE_ID ORDER BY EVE_DATED"
Here's the code I was trying to advance to the next month:
<a fref="type.asp?iDate=<%= Server.URLEncode(DateAdd("m",1,iDate))%>"><%= (Left(MonthName(Month(DateAdd("m", 1, CurrentDay))),3)) %></a>
Can someone point me in the right direction? Thanks!