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"> SELECT * FROM apartmentrentals WHERE ID = #URL.recordID# AND MoveOutDate = 'NULL" </cfquery>
Can someone help me out with the correct syntax.