Forums
This topic is locked
Don´t show when date is in the past
Posted 29 Aug 2001 12:25:06
1
has voted
29 Aug 2001 12:25:06 Hans Gelok posted:
<font face='Verdana'>Hi, I have this table with events. Is it possible to show only those events which are in the future? In other words: Don´t show when date is in the past.</font id='Verdana'>
Replies
Replied 29 Aug 2001 13:27:13
29 Aug 2001 13:27:13 Joel Martinez replied:
Sure it is, just make the SQL look something like this:<pre id=code><font face=courier size=2 id=code>SELECT * FROM events
WHERE eventDate >= mm_today</font id=code></pre id=code><b>Parameters</b>: mm_today = date
Joel Martinez [ ]
----------
set rs = conn.execute("SELECT answer FROM brain WHERE question = "& forumPost &"
'2nd place is just 1st Loser
WHERE eventDate >= mm_today</font id=code></pre id=code><b>Parameters</b>: mm_today = date
Joel Martinez [ ]
----------
set rs = conn.execute("SELECT answer FROM brain WHERE question = "& forumPost &"
'2nd place is just 1st Loser