I have a Database that stores a residentID, apartment, MoveInDate, and MoveOutDate.
I am trying to run a query from this database to find the resident row where the MoveOutDate is NULL so I can enter the date they moved out. My Coldfusion is not the best and here is what I have been trying to do with no avail.
<cfquery datasource="residents" name="getrentals">
WHERE ID = #URL.recordID# AND MoveOutDate = 'NULL"