CFIF based on time range

I think you have mentioned a viable solution yourself. Twice in fact. 🙂

Scheduled task.

The URL attribute of the cfschedule tag should point to your CFM page and the interval attribute should be 600 (the number of seconds in 10 mintes)

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#"> 

Can't say for sure without knowing your schema, but a pseudocode example might be:

SELECT col1

FROM myTable

WHERE timeCompleted = <cfqueryparam value="01-Jan-1970 00:00:00" />

This will get anything that has not been run, period.  (Assuming the database is using that value as the default value when the record is inserted and does not supply a time/date.)

V/r,

^ _ ^

Here's the thing.  If you are running it every ten minutes, the CFIF isn't required.  You should just add a column to the table for time/date completed, and if it's set to a default value of 01-Jan-1970 00:00:00, then run it and set the completion time/date to now(), after it completes.  Otherwise, do nothing.

HTH,

^ _ ^