EntityLoad dates to the future

Question

I have an event table. I am trying to display a list of all events in the future. I use orm, but I can not understand how much I will choose dates in the future. Filters accept only "=", not ">". I currently have this, but it clearly does not work:

var events = entityLoad("tbl_events",{"eventActive" = 1, "eventDate" > NOW()},"EventDate Asc",{maxResults = count});

Answer 1

You must use HQL

http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSf0ed2a6d7fb07688310730d81223d0356fc-7ffe.html

var events = ormExecuteQuery(from tbl_events where eventActive = 1 AND eventDate > ?, [now()]);