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