Having a issue with coldfusion. I just need a simple way to see if a date has passed and if so to update a field in a database. basically I have events showing on a page but want to remove the event automactically when it is over. Thanks for the help in advance..
azgold
0
Newbie Poster
Recommended Answers
Jump to PostWhile you can do this in coldfusion, it's probably faster to do it directly in SQL.
<cfquery name="getEvents" datasource=""> SELECT id, name, description, date FROM events WHERE date > now() </cfquery>
If you didn't store the date as a date field in the DB, then you …
All 2 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.