Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
expiry date
0 views
Skip to first unread message
Lloyd Phillips
Sep 30, 2001, 2:08:38 PM9/30/01
to
I am trying to create an events page for a website for people to list there
events in. I have got the page to list the events and have also created a
system whereby the browser can select events by region in a drop down box.
However I also want to show events that are forthcoming. That is that events
that have expired are not shown. I have done the other work as an SQL
statement and would have thought the easiest way would be to compare the
event date in the database to today's date:
events in. I have got the page to list the events and have also created a
system whereby the browser can select events by region in a drop down box.
However I also want to show events that are forthcoming. That is that events
that have expired are not shown. I have done the other work as an SQL
statement and would have thought the easiest way would be to compare the
event date in the database to today's date:
eg SELECT * FROM events WHERE event_date>="' & dtToday & '" AND
event_status=2
(event status shows that the event has been approved.)
This doesn't seem to work. Is there any better way of doing it?
Lloyd Phillips
0 new messages