I am writing a page that will automatically send an email that will come as a text message to instructors who did not insert the names of their pupils into the daily attendance log. My code will run through the database each day to see which of the instructor's ID is not listed.
If there is no ID of the instructor in the attendance database, that will mean that the instructor did not enter anything for their daily attendance. Even if no student show up to class, there is a "class cancelled" name that can selected. Some days one ID may come up, other days as much as ten of the instructors ID's number may come up.
The problem I am having is whenever there are multiple IDs that output from the query, I want to send an email to each of these instructors that the ID's match by using one cfmail tag.
Here my code below... Is there something I'm missing?
<!---Grab today's date--->
<cfset missingdate = NOW()>
<!---List all of the teachers ID--->
<cfquery name="squadlt" datasource="master">
select ltid from squadlt
<!---find out which instructors did not insert their pupils attendance--->