Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
I am programming my first dynamic site for a local music company and I am doing it in coldfusion on request by the client. Anyways, the site has a "shows.cfm" page that displays all of the upcoming local music shows in the area as submitted by users into the database. The problem I am having is how do I query so that the only shows that get posted are upcoming shows, and it doesnt get the shows that have already passed. I need it to filter by date but I can not figure out how. What would be the easiest way to go about this? any help would be greatly appreciated. Thanks