<!--- Loop over query. ---> <cfloop query="qTest"> <!--- Check condition for deleting. ---> <cfif (qTest.id EQ 4)> <!--- Delete this record. ---> <cfset qTest.DeleteRows( JavaCast( "int", (qTest.CurrentRow - 1) ), JavaCast( "int", 1 ) ) /> <!--- We only want to delete one record. ---> <cfbreak /> </cfif> </cfloop>