Problem with Mach-ii and exception

[Dede]

Hello,

I don't know if the previous message was published or not. If so, sorry for the twice document.


I work with CF9 and Mach-ii.

The problem is:

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

Here, the mistake is " WHERE field_ID = null "

Mach-ii doesn't intercept the mistake no exception occur.

Result: When the user update the informations, he think that all are saved because the system show "modification saved".
            In reality, nothing are saved and no message of mistake is displayed.

How can intercept this mistake ?

Your support will be appreciated
Thank you

Best regards

Andre