Mach-II doesn't generate a exception

[Dede]

Hello everybody

I work with CF9 and Mach-II.

I have a problem.

When you see the following SQL

<cfquery name="Query" datasource="db" >
    UPDATE table
          SET field1 = 123,
                 field2 = "abc"
     WHERE ID = null
</cfquery>

As you see, the mistake is " WHERE ID = null "

My problem: this error doesn't generate an exception.

Result: the user think to update the data, the system show that update is saved but in reality, nothing are saved.

How can I catch this mistake ?

It is only one example, other does exist.


Your help is welcome
Thank you for your help
Best regards

Andre