Does anyone know how to display the upcoming events on another web page outside of the default.asp forum page?
I have it almost set, but once the event is passed, I want it to disappear. My site is http://www.tsarcs.com.
The code to produce that is:
strSQL = "SELECT TOP 5 FORUM_TOPICS.T_ISEVENT, FORUM_TOPICS.TOPIC_ID, FORUM_TOPICS.T_SUBJECT,"_
& " FORUM_CAL_EVENTS.EVENT_DATE, FORUM_CAL_EVENTS.TOPIC_ID FROM FORUM_TOPICS, FORUM_CAL_EVENTS"_
& " WHERE FORUM_CAL_EVENTS.TOPIC_ID = FORUM_TOPICS.TOPIC_ID AND FORUM_TOPICS.T_ISEVENT=1 ORDER BY FORUM_CAL_EVENTS.EVENT_DATE"
I think I'm running into a problem, because the Snitz database uses a "text" field to store the date, instead of date/time.
I have played with this, but doesn't quite work, because it produces 9/11/2004, instead of 09/11/2004:
date = FormatDateTime(now(),2)
varDay = DatePart("d", date)
varMonth = DatePart("m", date)
varYear = DatePart("yyyy", date)
eDate = varYear & "/" & varMonth & "/" & varDay
WHERE Mid(FORUM_CAL_EVENTS.EVENT_DATE,5,2) & Mid(FORUM_CAL_EVENTS.EVENT_DATE,7,2) & Left(FORUM_CAL_EVENTS.EVENT_DATE,4) > eDate
Thanks for your help. I'm just learning this ASP coding stuff.
Rodney Skyles
Topic Locked
Posted - 12 September 2004 : 13:39:33
