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

<!--- Create the new query with proper columns. --->
<cfset qNew = QueryNew( qTest.ColumnList ) /> 
 
<!--- Loop over query. --->
<cfloop query="qTest">
	 
	<!--- Check condition for deleting. --->
	<cfif (qTest.id NEQ 4)>
		 
		<!--- 
			This is a good row, copy it over. Do this 
			by loop over columns and adding to new query.
		--->
		<cfset QueryAddRow( qNew )>
		 
		<!--- Loop over columns. --->
		<cfloop index="strColumn" list="#qTest.ColumnList#">
			 
			<!--- Copy over cell value. --->
			<cfset qNew[ strColumn ][ qNew.RecordCount ] =
				qTest[ strColumn ][ qTest.CurrentRow ] />
		 
		</cfloop>
		 
	</cfif>
 
</cfloop>

For Cut-and-Paste