This really sounds like a job for your SQL server to do the filtering of what jobs need to be done. For instance, if your column with the time (12:00) is a date/time in MySQL I would do something like : <cfset beginTime = timeFormat( now().add("n",-10), "HH:mm:ss") > <cfset endTime = timeFormat( now(), "HH:mm:ss") > SELECT id, theChannel, theTime FROM theTable WHERE TIME(theTime) >= <cfqueryparam value="#beginTime#"> AND TIME(theTime) <= <cfqueryparam value="#endTime#">
... View more