[snappy]

I created a calendar that has some fields for date and event name. Now I made it to work in a table format but now they want a list view as well.
When I do the loop to print the list view It ends up duplicating the Month Names if there is more than one event on that month. Needless to say I ma looking to trap the month name if more than one even falls on that month and only print the Month Name once.

Here is what I currently do to get the event name and Month/time stamp.

<% Set rsevent = Server.CreateObject("ADODB.RecordSet")
rsevent.Open "SELECT * FROM events Order by dates ", Conn, 1, 3
Do while NOT rsevent.EOF
rsdate = rsevent("dates") %>
<%=MonthName(Month(rsdate))%><br>

Name: <%=rsevent("event_name")%> / Date: <%=Day(rsdate)%>,&nbsp;<%=Year(rsdate)%> / Time: <%=FormatDateTime(rsdate, vbLongTime)%><br><br>

<% End If
rsevent.movenext
Loop
rsevent.close %>

FIY. The rsevent("dates") format in the SQL server is (3/2/2005 2:10:00 am) = March 3 2005 2:10 am

I am running in circles here. all help would really be appreciated. tia

[mathfxr]

where is ur if statement
only end if is there