Using ColdFusion Query's Underlying Java Methods For Query Manipulation And Logic

<!--- 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>

For Cut-and-Paste