Mach-II doesn't generate a exception

16 views
Skip to first unread message

Dede

unread,
Mar 27, 2014, 5:02:14 AM3/27/14
to mach-ii-for...@googlegroups.com
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
Reply all
Reply to author
Forward
0 new messages