Query of Queries doesn't support DELETE

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.

No comments: