I love queries in Coldfusion. Today I wanted to remove some rows from a Query so I just did a QoQ with a DELETE statement. Doc's clearly state don't support DELETE.
It took me a second, but the answer is simple, don't DELETE the records you don't want, SELECT the records you want back into the same query.
As a side note, I was working with CFLDAP and Active Directory. I was working on a test to make sure I don't lock out accounts if people are fat fingering or somebody is doing some sort of brut attack. I discovered Active Directory has a field that reports the number of failed logins since the last successful login.